Viewing 15 posts - 7,666 through 7,680 (of 11,676 total)
Maybe SSIS is using regional settings to determine the date format when writing to the destination flat file.
I would use the DT_STR datatype in SSIS (string datatype), convert the date...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 12:49 am
Regarding the extra rows:
if you type something in a cell in Excel and delete it, Excel will "remember" that there used to be data and you'll get null rows in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 12:44 am
http://en.wikipedia.org/wiki/Null-terminated_string
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 12:42 am
When you run this query, you get a really good description in the error of what is wrong...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 12:09 am
Nice back to basics question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 12:07 am
You still have IMEX=1 added in your connectionstring?
Did you modify the TypeGuessRows registry setting?
Is the type of the column in Excel set to Text, instead of General?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2012 at 2:52 pm
RonKyle (3/11/2012)
Without this, I haven't found a reason for turning the feature on.
So that the package doesn't crash when you use any kind of dynamic configuration?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2012 at 2:50 pm
Matt Miller (#4) (3/9/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 2:23 pm
This article explains how to read an object variable in a script task and how to put it in a dataset:
SSIS Design Pattern - Read a DataSet From Variable In...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 2:02 pm
mister boom (3/9/2012)
When I clicked MSDB, I got a message:"Failed to retrieve data for this request....The SQL server specified in SSIS service...."
I managed...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 2:00 pm
BSavoie (3/9/2012)
Seems like the best idea I've heard. I'm just not grasping how a derived column gets me around the problem. Can you give me a little bit more detail?Thanks!
Use...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 1:58 pm
L' Eomot Inversé (3/9/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 7:31 am
Look in the MSDB node instead of the File System one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 7:27 am
If you really want a web interface you can try Cognos Analysis Studio.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 7:17 am
J Livingston SQL (3/9/2012)
didnt deploy, cos to be quite frank, most of our users cannot understand the concept of slice/dice/summarise/drillthro....static reports for most of them :crazy:
It can...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 6:30 am
Viewing 15 posts - 7,666 through 7,680 (of 11,676 total)