Viewing 15 posts - 8,011 through 8,025 (of 11,678 total)
I would create 2 named ranges:
one for row 1 and the first 2 columns, to store the name and date.
one for the data starting at row 5.
You can write to...
February 10, 2012 at 1:29 am
What if you import is as unicode?
February 10, 2012 at 12:44 am
Nice question. I vaguely remembered reading something about this in my certification prep, it's not something I encounter daily.
February 10, 2012 at 12:17 am
Revenant (2/9/2012)
L' Eomot Inversé (2/9/2012)
MysteryJimbo (2/9/2012)
HowardW (2/9/2012)
MysteryJimbo (2/9/2012)
February 9, 2012 at 1:31 pm
What happens if you move the file with a script task using .NET (FileInfo.CopyTo ; FileInfo.Move ; FileInfo.Delete) instead of a file system task? You can log in a script...
February 9, 2012 at 1:29 pm
jcrawf02 (2/9/2012)
BrainDonor (2/9/2012)
Roy Ernest (2/9/2012)
Lynn Pettis (2/7/2012)
Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson...
February 9, 2012 at 10:03 am
Maybe you have only read rights on the folder, not modify/write?
Off-topic again 🙂
You're not circumventing data conversion issues by pumping it in a flat file.
Most data conversion issues occur when...
February 9, 2012 at 9:59 am
Linda Robinson (2/9/2012)
February 9, 2012 at 9:54 am
Gas Andy (2/9/2012)
I've started a new contract and registered for SQLServerCentral.com, so I had a brand new "clean" email address. I had not registered...
February 9, 2012 at 3:57 am
Rachel Byford (2/9/2012)
I am instead going to use Execute SQL tasks with begin tran/commit tran and rollback...
February 9, 2012 at 3:32 am
You should be able to execute a stored procedure in a report just fine. Change the command type of the query from text to stored procedure.
Regarding your set-up:
you could use...
February 9, 2012 at 3:29 am
SQL Kiwi (2/9/2012)
Koen Verbeeck (2/9/2012)
SQL Kiwi (2/9/2012)
There's really no need to use this any more anyway - we have XML PATH and CLR.
That is a bit of the problem.
XML PATH...
February 9, 2012 at 3:25 am
SQL Kiwi (2/9/2012)
There's really no need to use this any more anyway - we have XML PATH and CLR.
That is a bit of the problem.
XML PATH and CLR have a...
February 9, 2012 at 3:10 am
Good question, had to do a bit of research, but the MSDN link doesn't really back-up the explanation as it doesn't mention salt anywhere.
edit: in this thread, an MVP does...
February 9, 2012 at 12:41 am
There isn't really a "web service destination" in SSIS, so I think you're better of coding it in .NET. (or in another language)
February 9, 2012 at 12:35 am
Viewing 15 posts - 8,011 through 8,025 (of 11,678 total)