Viewing 15 posts - 9,211 through 9,225 (of 11,678 total)
If it happens only at your system, you should take a good look at your computer. Is there enough RAM?
Maybe you can try to re-install BIDS.
July 12, 2011 at 7:16 am
I see you have a for each loop, is the dataflow inside this loop?
The OnPreExecute and the OnPostExecute event handlers can be fired more than once (especially the ones on...
July 12, 2011 at 5:50 am
There are some many things that can cause this.
Do you open all the packages at the same time?
Do you use a lot of package configurations?
When SSIS opens a package, it...
July 12, 2011 at 1:58 am
Setting Precedence Constraints on Tasks and Containers:
http://msdn.microsoft.com/en-us/library/ms141221.aspx
Adding Expressions to Precedence Constraints:
http://msdn.microsoft.com/en-us/library/ms140153.aspx
1. Place your entire package logic in a single container
2. Before that container, put an empty script task.
3. Connect the...
July 11, 2011 at 11:35 pm
Just to make sure, is the project property Run64BitRunTime set to False?
Does the entire column show NULL values, or just some specific values?
July 11, 2011 at 11:30 pm
david-1008051 (7/11/2011)
Thanks for that, simple when you know how 🙂
No problem, glad to help! 🙂
July 11, 2011 at 2:13 pm
Christian Allaire (7/11/2011)
The data is read by the data source and shows up in the data viewer only if I run the the Data Flow Task directly...
July 11, 2011 at 2:10 pm
pamarthi.sudheer (7/11/2011)
Sorry.. Im not getting your reply.......
Question not clear. No information given.
--->
Do you get some errors?
What doesn't work?
Did you check the logs?
July 11, 2011 at 7:51 am
You need to run the package in 32-bit mode.
In the SSIS jobstep, there is a checkbox that you can select.
July 11, 2011 at 7:47 am
brazumich (7/11/2011)
Now waiting to see who says it should be worth two points since there were (sort of) two questions in one... :rolleyes:
This question wasn't worth two points???
:hehe:
July 11, 2011 at 6:26 am
How is this topic different from this one:
http://www.sqlservercentral.com/Forums/Topic1138118-148-1.aspx
Don't use the OLE DB source. Use string variables and the Execute SQL Task.
July 11, 2011 at 6:24 am
Janaa (7/11/2011)
July 11, 2011 at 6:22 am
After I've read Phil's comment about the way SSIS works, I started thinking about easier alternatives, and I've found one:
* you select the SQL statement from the table and store...
July 11, 2011 at 6:16 am
Viewing 15 posts - 9,211 through 9,225 (of 11,678 total)