you shud rather use the execute sql task for this.

Did you try Int16 for var1?

A way here to work out would be to make a variable in the package which takes its value from the XML configuration file. You can use the variable in...

i think i have found the source of the problem.

actually i am using script component to run the select query which opens and closes a connection.

I will now try to...

I tried doing this but it doesn't work.

I was just wondering does it have anything to do with the MSDTC service.

Will enabling or disabling it affect my solution?

thanks guys...the issue is resolved...the database was not attached...thats it...now its working fine..

gud work guys..

I have downloaded and installed adventureworksDB for SQL server 2005 but still i cant see it in my databases in my management studio.

When i try to create a OLE DB...

Can you be a little more elaborate?

lets say i have a database which is not case insensitive. how do i make it case sensitive?

please explain with example.

it worked for me.thanks david. u r genius

One c# problem:

i have a string 001516. i want to check if it contains colons or not.

i.e if it is in the format...

Thanks David, it worked for me.

One more problem:

Is there any way i can pick up the latest file from a given folder and copy it to a destination?

Even when i tried i found there is nothing like maxvalue defined for byte but apparantly there is.

See the below link:

http://msdn2.microsoft.com/en-us/library/system.byte.maxvalue(VS.71).aspx 

i have .dts files on my server itself. these are the dts which i want to save as a local package on the same machine.

The requirement is not to...

I tried to use UNC but its not working. the cmd says it does not support it.

here is the error message:

C:\Documents and Settings\nbkr3bi>cd \\172.17.16.117\apps\Services

'\\172.17.16.117\apps\Services'

CMD does not...

Can you please elaborate this method.

What are UNC names.

And how do i use in my stored proc.

Please give the syntax too if possible.

The OS is windows 2003 NT only. Is there any other way apart from mapping drives.

I have heard linked sever can be used. Do you know anything about it.