Viewing 15 posts - 10,006 through 10,020 (of 11,678 total)
First of all, this is an SSIS Script Task, not an Execute SQL Task.
Regarding your error, you cannot reference SSIS variables like that.
You need to use Dts.Variables("Code").Value to get the...
March 1, 2011 at 3:52 am
Are there any errors or warnings?
March 1, 2011 at 3:48 am
The following article can have some great suggestions for you:
Not all best practices can be applied to your situation, but some of them ought to be useful.
Regarding the INSERTS in...
March 1, 2011 at 3:44 am
If you can't process the SQL 2000 cube with the Analysis Services Processing Task, there are alternatives to do the same.
March 1, 2011 at 3:38 am
What is the exact reason that Validate External Metadata has to be set to false. I don't see the connection with transactions. Do you get any errors or warnings?
The reason...
March 1, 2011 at 3:30 am
reem_kn (2/28/2011)
Please I need help about this problemI don't understand the solution
To execute a package on the server, the user has to have permissions to execute the system stored procedure...
March 1, 2011 at 2:28 am
Read the whole file in as one column, then use a conditional split to split the data stream into 3 flows.
For each flow, use a script component to split out...
March 1, 2011 at 2:19 am
davepc (2/28/2011)
Yes. LastModifiedDateTime would work if you don't need to capture all change and don't allow deletions (which is a different story).
If you allow deletions and don't just mark...
February 28, 2011 at 11:29 pm
CirquedeSQLeil (2/28/2011)
February 28, 2011 at 11:26 pm
TravisDBA (2/28/2011)
February 28, 2011 at 11:25 pm
GSquared (2/28/2011)
Kiara (2/28/2011)
jcrawf02 (2/28/2011)
Stefan Krzywicki (2/28/2011)
jcrawf02 (2/28/2011)
February 28, 2011 at 11:21 pm
quickdraw (2/28/2011)
One additional thing I did is to reverse...
February 28, 2011 at 11:34 am
GSquared (2/28/2011)
Koen Verbeeck (2/28/2011)
Ugh. The "cloud". Management buzzword of the past few years.
I have already been working with a cloud based email and messaging system.
It is called Hotmail... 😎
And between...
February 28, 2011 at 11:11 am
amenjonathan (2/28/2011)
February 28, 2011 at 11:08 am
Viewing 15 posts - 10,006 through 10,020 (of 11,678 total)