Viewing 15 posts - 1 through 15 (of 63 total)
I tried the pivot transformation in two ways, initially with a query using a case statement, then using the pivot transformation in SSIS. Both produced the same result.
I'll look at...
November 7, 2011 at 5:56 am
That needs the row_number over (partition, order) feature, and I don't know if MySQL supports it.
Unfortunately it doesn't. This is really starting to get me stuck....Another option might be to...
February 7, 2011 at 5:49 am
thx for that, that did work. But (there always is a "but") I have checked further into the different scenarios, and found that there are other ways the data can...
February 7, 2011 at 3:53 am
They are actually date time columns.... MySQL allows storage of this in a date time column as a dummy value.
The problem just is how to query the data... :ermm:
February 5, 2011 at 1:38 am
I've actually just found a solution to the problem.....
INstead of scheduling the job normally in SQL Agent, and checking all the boxes for the connections etc, I checked the radio...
October 5, 2010 at 7:15 am
Does the SQL Server Agent account has the necessary privileges to access the Excel file?
Sounds like this might be the cause....how can I check this though?
Thx
October 5, 2010 at 4:00 am
And what about configurations? Do you use config files/tables?
Where would these be used? I haven't used anything like that at all...
October 4, 2010 at 2:44 pm
The package is running fine in Visual Studio (and also if I run the *.dtsx file outside of VS 2005), and although I didn't post my whole connection string, I...
October 4, 2010 at 7:29 am
Yep...thats finally what I have had to do.
Seems strange though that the final task seems to transform the data on its own. even if u tell it not to!
April 9, 2010 at 8:17 am
Have also tried that using a data conversion tool. But it does not seem to make any difference whether the format of the field has been set in a string...
April 9, 2010 at 7:12 am
I am also having a very similar problem.
I have a numeric field, (18,2) that needs to be exported to a csv file, but when it gets exported any zero values...
April 9, 2010 at 6:48 am
Thx - that looks great! :w00t:
Gonna give it a try on Monday (other priorities have shifted it from today) and let you know
April 9, 2010 at 6:29 am
That is what I have described in the first post...
I can make the script so it searches for a particular file, but when the file (or files) have different names,...
April 8, 2010 at 1:09 am
Actually now decided that if the For Each Loop is taking care of sweeping through the folder, I don't actually need the Script task.
Would be nice to know how to...
April 7, 2010 at 7:09 am
Viewing 15 posts - 1 through 15 (of 63 total)