Viewing 15 posts - 11,191 through 11,205 (of 11,676 total)
Hi.
Why don't you use an Excel Source and an OLE DB Destination to accomplish this?
August 20, 2010 at 12:26 am
jessekraut (8/19/2010)
With the Microsoft OLE DB Provider for DB2 driver we are finding that the OLE DB Destination Data Access mode does not have a choice for a Fast Load.
That...
August 19, 2010 at 11:56 pm
Nice question!
I learned something new about SSIS, a product I work with every day.
(I got it right, but only after some experimenting in SSIS).
August 19, 2010 at 8:42 am
river22_34 (8/19/2010)
Please provide me the complete solution.
Sorry if this sounds rude:
if you want the complete solution, hire a consultant.
Phil and I have given you enough hints so that you can...
August 19, 2010 at 7:20 am
Phil Parkin (8/19/2010)
da-zero (8/19/2010)
http://www.google.com/search?source=ig&hl=nl&rlz=1G1GGLQ_NLBE331&q=ssis+ebook&aq=f&aqi=g1&aql=&oq=&gs_rfai=Now who would have thought of doing that? 🙂
Well, apparently the original poster didn't. 🙂
Phil Parkin (8/19/2010)
In Dutch too.
Dammit, I remembered to change the .be to...
August 19, 2010 at 6:25 am
Use the stored procedure in an OLE DB Source and then connect your input with an OLE DB Destination component.
To use the input parameters, it is best that you store...
August 19, 2010 at 6:19 am
Professional Microsoft SQL Server 2008 Integrations Services from Wrox is a very complete and comprehensive book on SSIS. It covers too many subjects for a beginner, but you can read...
August 19, 2010 at 5:43 am
Well, one thing that can go wrong is the connection strings to your databases. In 2008 they differ lightly from the 2005 version.
August 18, 2010 at 3:06 am
Paul_Harvey (8/18/2010)
When I open one of my SSIS packages in Visual Studio, the control flow screen alway open on the bottom right of the "canvas", and...
August 18, 2010 at 3:03 am
Raunak Jhawar (8/18/2010)
Phil Parkin (8/18/2010)
veera.1255 (8/18/2010)
Any one can send the rly to these questions these questions are faced by me as a 2+experience in ssrs
This is an SSIS forum,...
August 18, 2010 at 2:59 am
The solution you worked out seems fine to me.
You only need to make sure that no other .txt or .xls file comes in with a different metadata structure, as it...
August 18, 2010 at 12:45 am
That is indeed very odd. Maybe even SSIS can have the Monday blues?
August 17, 2010 at 12:57 am
If you use trim functions in the lookup component, don't forget to provide aliases for the columns!
(sorry, I forgot to mention that sooner :))
If you don't do that, every column...
August 16, 2010 at 11:55 pm
Viewing 15 posts - 11,191 through 11,205 (of 11,676 total)