Viewing 15 posts - 9,346 through 9,360 (of 11,678 total)
This should be OK, since you could browse the cube before the modifications, but did you check the dimension usage tab to see if everything is connected correctly?
May 30, 2011 at 4:53 am
Regarding issue #1: your code appends data to the variable for every iteration. So what did you expect?
Store the fixed part in another variable, and create each time the varFileLocation:
varFileLocation...
May 30, 2011 at 12:01 am
Regarding the quotations: this is to indicate that the text contains a delimiter. In this case, a comma.
You can convert the data to currency inside the dataflow, using a derived...
May 29, 2011 at 11:55 pm
If you set up the event handlers on the package level, do they work?
How do you fail the Execute SQL Task?
May 29, 2011 at 11:51 pm
If you set-up a dataviewer right before the Excel Destination, is the precision there still correct ?
May 29, 2011 at 11:46 pm
The EXEC is screwing with your metadata, as the first statement in your sp is not a select statement.
Read the following article:
http://sqlserverpedia.com/blog/sql-server-bloggers/ssis-stored-procedure-metadata/
May 29, 2011 at 11:42 pm
@quillis: is it possible to post the query?
@sririam: read this blog post: http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/stored-procedures-are-not-parameterized-views.aspx
It is best to avoid stored procedures in the OLE DB source, as they do not garantuee metadata...
May 29, 2011 at 11:24 pm
The data conversion component doesn't actually convert the columns, it makes copies of those columns with the desired data type.
Did you remap the columns in the destination?
May 28, 2011 at 4:50 am
Can you browse the dimensions itself in their respective editors?
May 28, 2011 at 4:49 am
You can browse the cube in SQL Server Management studio or in Excel.
May 27, 2011 at 6:28 am
Maybe a stupid question:
did you refresh/reconnect the browser?
May 27, 2011 at 6:28 am
What syntax did you use to indicate the parameters?
Another option is to use a stored procedure in the source.
May 27, 2011 at 12:28 am
SKYBVI (5/26/2011)
I click on .dtsx file and copybut when i open another package
i cant paste tht .dtsx file here.
Regards,
Sushant
You copy the .dtsx files in the Windows itself.
Then you go the...
May 27, 2011 at 12:27 am
Viewing 15 posts - 9,346 through 9,360 (of 11,678 total)