Viewing 15 posts - 241 through 255 (of 699 total)
Could you, instead of using a query, maybe try putting the query into a stored procedure then executing that procedure?
October 18, 2011 at 10:06 am
Might not be the most elegant solution, but I've found I've been able to get it to work by using an ODBC driver instead.
October 18, 2011 at 8:26 am
What exactly are you looking to test?
Usually the way I test my packages is just to run them against sample data and see if the input produces the expected outputs.
October 18, 2011 at 6:36 am
The one place where I could see it hanging for some reason, without throwing an error, would be at the execute process task.
If you're executing a process and for whatever...
October 18, 2011 at 6:35 am
Try putting a data viewer right after your derived column transformation, and then view the data exiting that transformation. See if the derived column you've created contains the dummy date...
October 17, 2011 at 1:53 pm
What is it getting instead? The NULL value?
October 17, 2011 at 12:48 pm
What do you mean by that, exactly? You're saying your source has a NULL value, and in your destination, you get an error saying you can't write a NULL value...
October 17, 2011 at 11:15 am
If you're using ISNULL in SSIS, then the way you need to use it for your purposes is something like:
ISNULL(column) ? (VALUE_IF_TRUE) : (VALUE_IF_FALSE)
So, for example,
ISNULL(column) ? "1950-01-01" : column
Since...
October 17, 2011 at 11:01 am
Can you look at the jobs scheduled and find the list of the scheduled jobs which run at that time, then look at them one at a time?
If not, another...
October 17, 2011 at 10:32 am
Yeap, exactly what Ron suggested. Excel destinations are notoriously bad for misinterpreting what you're trying to feed in to them. Having a dummy row lets the system figure out what...
October 17, 2011 at 9:55 am
October 14, 2011 at 11:54 am
You're just doing imports, not trying to update anything in an excel spreadsheet right? If so, that URL you're referencing isn't really what you want. What you want is much...
October 12, 2011 at 4:21 pm
Can you rely on the format of the excel file name to contain the date? And if so, is your request to have the file corresponding to the most recent...
October 12, 2011 at 1:05 pm
Yeah I'll echo drew and phil on this one.
IMO your best bet is to have your data exist in two tables. One table will be something like FileNames, and will...
October 12, 2011 at 12:56 pm
If you go into the connection manager properties for SPIN-2, and verify the connection info and username/password then hit "TEST CONNECTION", does it return a message saying the test was...
October 11, 2011 at 8:23 am
Viewing 15 posts - 241 through 255 (of 699 total)