Viewing 15 posts - 7,801 through 7,815 (of 11,678 total)
OK.
Is it possible to post the exact expression that sets the connectionstring to the Excel file?
Also make sure the Excel file is closed when you run the package.
February 28, 2012 at 2:54 am
Yes, use the OLE DB Destination with the Fast Load option in favor of the SQL Server Destination.
What do you mean with "any good articles for 2K"?
Do you mean for...
February 28, 2012 at 2:52 am
Are you able to open the Excel Source editor and do a preview of the data?
February 28, 2012 at 2:23 am
What do you mean with "job"?
Do you mean an SSIS package or a SQL Server Agent job?
February 28, 2012 at 1:52 am
Can you elaborate more?
It first sight this doesn't give a problem. The facts all have the same business key, so only 1 inferred member is generated.
When the SCD2 dimension records...
February 28, 2012 at 1:00 am
Did you set the DelayValidation property of the dataflow to TRUE?
February 28, 2012 at 12:46 am
Jayanth_Kurup (2/28/2012)
February 28, 2012 at 12:37 am
Why are you using ADO.NET instead of an Excel source?
Try putting double quotes around your filepath and around the extended properties:
Data Source="G:\EXCEL TO SSMS\wave2_CM.xls";Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
February 28, 2012 at 12:32 am
Can you post the expression?
February 28, 2012 at 12:16 am
It would be great if you posted the connectionstrings and the expressions that build them.
February 28, 2012 at 12:14 am
Is it possible to post the entire error message?
February 27, 2012 at 11:53 pm
How are you going to fire the Execute Process Task at the beginning of the package and at the end of the package as well?
February 27, 2012 at 11:51 pm
Welsh Corgi (2/27/2012)
RonKyle (2/27/2012)
Why did you opt for a...
February 27, 2012 at 11:47 pm
How do you populate the datasets? With a SQL query?
Wich data container did you use? Table, matrix, list?
February 27, 2012 at 11:38 pm
1. Which version of Excel are you using? There are 64-bit providers available for the ACE OLE DB provider.
2. Do you get the error in BIDS or at server? The...
February 27, 2012 at 11:37 pm
Viewing 15 posts - 7,801 through 7,815 (of 11,678 total)