Viewing 15 posts - 11,926 through 11,940 (of 13,874 total)
Rich-403221 (8/11/2010)
:ermm: Phil, my apologies.Should have tried it a little more before I ASSUMED that SSIS would be logical. Guess it's not as straight forward as I thought.
Rich
No problem -...
August 11, 2010 at 11:10 am
Sounds like a plan.
If you export from Excel to CSV after performing this reformatting, is the formatting of the field the same as was originally output?
If not, what happens if...
August 11, 2010 at 9:55 am
Baskar B.V (8/11/2010)
Phil Parkin (8/11/2010)
But if the table doesn't exist at design time, you can't create the dataflow.
have done data population dynamic using DTS... We pulled the column info using...
August 11, 2010 at 9:40 am
Rich-403221 (8/11/2010)
August 11, 2010 at 9:38 am
But if the table doesn't exist at design time, you can't create the dataflow.
August 11, 2010 at 9:15 am
If you want to put data in them too, you might find this a challenge.
August 11, 2010 at 9:10 am
stricknyn (8/11/2010)
Phil Parkin (8/10/2010)
Code reuse in SSIS is not as easy as it could be....
August 11, 2010 at 9:03 am
Why are you writing in code? This is not a crossword forum.
If you want help about a specific topic, please ask a question.
August 11, 2010 at 8:59 am
Baskar B.V (8/10/2010)
MostInterestingMan (8/10/2010)
I have a date column with data type DT_DBTIMESTAMP that I am exporting to .csv. In the Flat Connection Manager the data type is correct and I...
August 10, 2010 at 11:52 pm
Excel is helpfully (:crazy:) doing the conversion for you. Try opening it in Notepad and you'll see that it's just the same as the .txt.
August 10, 2010 at 2:06 pm
We don't use control-M on these servers so I need to use SQL Agent to run this package. Is there any way other then installing SSIS ?
Not that I know...
August 10, 2010 at 2:03 pm
What are you using to view the CSV?
August 10, 2010 at 1:52 pm
Here[/url] is a nice article, though probably not applicable to your scenario. Worth a read anyway.
Code reuse in SSIS is not as easy as it could be. To do what...
August 10, 2010 at 12:54 pm
Expanding a little on this, you could use linked Sequence containers to get the exact concurrency and processing order you require.
August 10, 2010 at 10:24 am
Brandie Tarvin (8/10/2010)
But I'm not mistaken, am I, that 0 as a value should work fine in a Double...
August 10, 2010 at 6:01 am
Viewing 15 posts - 11,926 through 11,940 (of 13,874 total)