Viewing 15 posts - 4,621 through 4,635 (of 11,678 total)
The regular toolbox is normal, the SSIS toolbox however not.
You are using the SSDT that comes with the SQL Server installation right?
October 8, 2013 at 1:26 am
You could use the delimited split function by Jeff Moden:
Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]
It returns a table with the various parts and their positions, so you...
October 7, 2013 at 3:38 pm
AndrewSQLDBA (10/7/2013)
I have had some SSIS packages that I converted to SQL 2012 using the SQL tools, what was once BIDS. I would like to edit one, but none...
October 7, 2013 at 3:16 pm
You should start with a good book, which will probably answer most of those questions.
Start with the Data Warehouse Toolkit by Ralph Kimball.
October 7, 2013 at 1:33 pm
How is the data retrieved from the database? I guess with a query? Modify the query so that no duplicate data is retrieved.
October 7, 2013 at 1:30 pm
Are there more details in Event viewer or in the setup log?
October 7, 2013 at 3:18 am
damien.gulluni (10/7/2013)
What I am looking for, and thank you again for your time,...
October 7, 2013 at 2:54 am
damien.gulluni (10/7/2013)
October 7, 2013 at 2:40 am
It seems to me your text qualifiers are the problem, not the commas.
Anyway, all of these issues can easily be avoided by choosing a decent delimiter.
October 7, 2013 at 2:24 am
damien.gulluni (10/7/2013)
First of All, thanks for your reply. I already tried with a Flat File Connection; but the error occurred directly on the Flat File Source.
The solution I am...
October 7, 2013 at 2:17 am
Very nice question, thanks.
October 6, 2013 at 2:26 pm
kalaiselvan.rajendran (10/4/2013)
And Aggregation Transformation to SUM the Values for Measure Columns.
Without Using these How Can i...
October 6, 2013 at 1:47 pm
mitzyturbo (10/4/2013)
I have it set to NO but it makes no difference
You still have to map columns. SSIS needs fixed metadata.
If you have no header, the column names should be...
October 4, 2013 at 6:49 am
In the connection string you can indicate that there is no header line.
Set HDR=YES to HDR=NO.
October 4, 2013 at 6:02 am
Viewing 15 posts - 4,621 through 4,635 (of 11,678 total)