ssis

Question

Post reply

ssis

SAT_SQL

Default port

Points: 1465
More actions
August 11, 2009 at 8:29 pm

#203708

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ells SSCrazy Eights Points: 9901 More actions · Answer 1

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.

amir.mochtar Old Hand Points: 323 More actions · Answer 2

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??

JasonYousef SSCommitted Points: 1769 More actions · Answer 3

Amir, you'll use execute SQL task and use your SQL query.

amir.mochtar Old Hand Points: 323 More actions · Answer 4

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

Ryan Meyer-460012 SSC Rookie Points: 30 More actions · Answer 5

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.