Viewing 15 posts - 10,201 through 10,215 (of 13,879 total)
I echo others' comments about DDL ...
But also noticed that your SQL has a spurious comma between
't2.dbo.tblQuestions.Question'
and 'FROM'
January 28, 2013 at 4:10 am
quillis131 (1/23/2013)
samvanga (1/22/2013)
It's metadata driven and allows you to automate SSIS package generation.
I've implemented this...
January 28, 2013 at 4:02 am
I imagine so.
At worst, SSIS can create the file locally and then you can use a Script Task with whatever C# code is required to achieve this.
But never tried...
January 24, 2013 at 11:10 am
vax09 (1/24/2013)
columns are defined but the problem is when i run the second package it start from...
January 24, 2013 at 11:05 am
Why not get yourself a copy of SQL Server Express 2012 and restore the db to an instance there.
Here's a link. You should get one of the Management Studio versions...
January 22, 2013 at 1:41 pm
What's your data source?
If it's an RDBMS of some sort, you could always change it to a query containing a UNION:
select [good stuff]
union
select [vapour stuff]
January 21, 2013 at 11:49 am
You're on the right track, I think.
But what I would do is create a try ... catch block and attempt to do the convert to date in the 'try' bit....
January 21, 2013 at 11:43 am
I'd probably leave the package exporting to a fixed file name and add a final File System Task (or Script Task if you prefer to write a bit of code)...
January 19, 2013 at 9:24 am
Have you tried using a data conversion component?
January 18, 2013 at 3:16 am
--Statement 2
select * from @Table1
where (column2 != 'AP' or column3 != 'U')
January 17, 2013 at 3:30 pm
After your Excel source, add a data conversion component.
Use it to convert your problematical column to DT_STR. You will see at this point that you are able to specify the...
January 17, 2013 at 5:47 am
I would guess that you have created a column in your dataflow called 'Copy of SSN' and that the error is occurring because you have mapped this column to one...
January 16, 2013 at 6:13 am
Nice error message. What's your question exactly?
January 16, 2013 at 5:58 am
aaron.reese (1/15/2013)
Staging tables?What is this - SQL7? 😛
I would like to hear your reasons behind this comment. In many circumstances, a staging table SSIS solution will be one or...
January 15, 2013 at 1:22 pm
Viewing 15 posts - 10,201 through 10,215 (of 13,879 total)