August 11, 2009 at 8:29 pm
Hi all
i need to upload the csv file with huge records for that i want to shedule the ssis can any one help in basic,
and scripting , and what flow task i want to use.
regards
sat
August 13, 2009 at 1:21 am
Is it a regular load that you want to schedule?
If you are asking for a simple step by step to do this then
1. add a flat file connection manager to the package. Edit and add details
2. add a data flow task to the control flow.
3. add a SQL Server connection manager for where the data is going. Edit and add details
4. In the data flow add one flat file source. Edit it and add details.
5. Add ole db destination to data flow task. Edit and add details.
6. Drag the green line from flat file source to OLE DB destination.
7. Edit the OLE DB destination and sort out the mapping from source to destination.
Thats the bare basic no frills version.
Ells.
August 11, 2011 at 2:36 am
need help, i have sql statement like this :
select col0, col1, col2
from table1
where substring(col0,1,3) IN (select colref from tableRef where active=1)
if want to convert this statement with SSIS component (bold mark). which component should i use??
August 15, 2011 at 1:03 pm
Amir, you'll use execute SQL task and use your SQL query.
August 16, 2011 at 3:54 am
huslayer (8/15/2011)
Amir, you'll use execute SQL task and use your SQL query.
oohh, so it doesn't need to be split, does it? ... i thought it should split with use such as lookup or merge join component 😀 .
i tried to execute 200.000 records, it seems take too long with those components.... hhmmmm
thanks, anyway
August 16, 2011 at 11:05 am
It depends on what you want to do. Execute SQL Task is generally not used to return a result set. I usually use it for updates, deletes, etc.
If you are planning to take the result of this query and put it into a dataflow, you will want to use one of the Data Flow Sources, like OLE DB Source, then set data access mode to SQL Command, populating the SQL Command Text with your select statement.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply