PackageVariable setting does not work in another environment

hi

I have this variable setting in C# in my self developement project works fine.

but when i implement it in actual project does not work.

/Set \\package.Variables[User::ArchiveExcelFileConnectSt].Properties[Value];\"" + xlspath + "\"

when i test it in SQl query analyzer i need to replace // with / and works fine. but when i implement in c# it does not in my actual project. both have different Database.

Do i need to turn on some thing in my Actual Databas that my project points too or is there some thing else.

Thanks,

Jasmien

Take a look at this thread...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=660132&SiteID=1

Are you trying to do this in a SQL statement? Or are you using the Microsoft.SQLServer.ManagedDTS library?

|||

i fixed that problem . I was basically my production was pointing to one database and in part of my code i was trying to over write with my local database so it was conflicting.

sql

Overlay lines on x axis

I need to overlay the bar lines on a chart in reporting services. I
have actual and budget numbers that need to be displayed, but they
need to be overlayed, not side by side as the column chart does by
default. Any ideas on how to do this?
Thanks,
JoshDid you look at this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c229b25c-b2dc-41ac-923d-decbb253dc6e&sloc=en-us
It is possible to combine column and line charts. However, this is not
possible for bar and line charts.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Josh Harris" <joshua_c_harris@.hotmail.com> wrote in message
news:eda768cf.0411241126.4e25fb10@.posting.google.com...
> I need to overlay the bar lines on a chart in reporting services. I
> have actual and budget numbers that need to be displayed, but they
> need to be overlayed, not side by side as the column chart does by
> default. Any ideas on how to do this?
> Thanks,
> Josh