Viewing 15 posts - 16 through 30 (of 191 total)
The error message seems to suggest a datatype conversion problem...
What datatype does the stored procedure parameter expect and what is the datatype of the variable you're passing into it?
HTH
October 6, 2009 at 6:17 am
Hi,
You say you are writing to a txt file. Do you need to write the last row in the same dataflow?
Could you not write the results to file whilst capturing...
October 6, 2009 at 6:13 am
Hi Eric,
- this "Data Warehouse" does not include any time dimension and has therefore no concept of "slowly changing dimension"
If what you're saying is that the proposed "solution" doesn't capture...
October 6, 2009 at 5:43 am
The ExecutionInstanceGuid system variable should be mapped as a string. It's unintuitive but if you map it to your parameter as a GUID it gets translated into another value entirely.
October 2, 2009 at 6:18 am
Thanks Steve, it turned out to be me anyways... I didn't even realise I had 2 accounts on the go!
September 16, 2009 at 11:13 am
No problem bt... thanks for posting the resolution too. It's always helpful to all to know the outcome.
Cheers
August 26, 2009 at 2:27 am
No problem bt... thanks for posting the resolution too. It's always helpful to all to know the outcome.
Edit: Apologies for the double post, my browser crashed when I hit the...
August 26, 2009 at 2:24 am
When I run the pkg from Visual Studio or directly from the SSIS File System, it runs fun and loads table (the pkg consumes the Variable value defined w/ the...
August 21, 2009 at 7:25 am
Hi Naveen,
Is there a reason why this has to be part of a transaction? Generally with batch inserts you populate the master table first, then lookup the newly inserted data...
August 18, 2009 at 3:05 am
Given that you are already able to delete the directory can we assume you've got a foreach file enumerator set up? If so then you just need to place another...
August 14, 2009 at 11:43 am
You can also use the OleDB GetSchema() method. I can't remember the exact syntax, but a search of msdn should help.
This allows you to query the excel catalog information without...
August 14, 2009 at 10:29 am
The [Order Date] column is being read as non unicode.
You could cast it to unicode in your select statement
e.g. SELECT CAST([Order Date] AS NVARCHAR(20)) AS [Order Date]
FROM MyTable
Ideally though, especially...
August 14, 2009 at 8:12 am
John,
That was one of the best posts I've read on this forum. Great response.
If you ever had time, that would be a great subject for an article too.
Cheers
August 14, 2009 at 7:51 am
Are you using a mapped drive or the fully qualified UNC?
If your prod server doesn't have the same mapped drive as the test / development package then it won't...
August 13, 2009 at 8:12 am
Viewing 15 posts - 16 through 30 (of 191 total)