Viewing 15 posts - 11,086 through 11,100 (of 11,676 total)
Phil Parkin (9/20/2010)
vince.chevens (9/20/2010)
How about installing SSIS component of SQL2005 only on your server--comment deleted--
Now, that just makes me curious 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 21, 2010 at 12:38 am
Steve Jones - Editor (9/20/2010)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2010 at 1:16 pm
Doug Lane (9/20/2010)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2010 at 1:15 pm
In our environment they are against using stored procedures, for the simple reason that if you deploy your SSIS packages, you could forget to deploy your stored procedures. And then...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2010 at 8:31 am
Just for curiosity: what was the issue? (and how did you solve it?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2010 at 8:27 am
Good question. Keep 'em coming!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2010 at 3:01 am
Allright, it is time to dive into the details.
How did you set-up your packages? What tasks/components did you use? What connectors did you use? What are the expressions/variables/package configurations that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2010 at 2:01 am
You have two options:
* read everything as string, replace the NULL strings and then convert everything to the appropriate datatype.
* use a script task to read the file and replace...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2010 at 7:23 am
If you write the data to a table, what are the actual values that you get?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2010 at 5:26 am
CirquedeSQLeil (9/16/2010)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2010 at 3:07 am
Are you running in 32-bit or in 64-bit mode?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2010 at 3:04 am
Good question, but a real easy one since all the rounding questions of Hugo Kornelis. 🙂
It would've been more a challenge if you used 3.2 or 3.0, as someone already...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 17, 2010 at 2:54 am
tgarber (9/16/2010)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 16, 2010 at 1:33 pm
To conclude: I really was pointing out the obvious irony 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 16, 2010 at 12:55 pm
Totally off-topic:
why are you calling a stored procedure per row? Isn't it more effective to call the stored procedure on a set?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 16, 2010 at 7:31 am
Viewing 15 posts - 11,086 through 11,100 (of 11,676 total)