Flat file to query help needed

[onyxtacular]

I'm new to ssis and need some help. I have a csv file I need to use as a parameter to get some information and then update it.

Here's how it looks in crystal reports...

SELECT "Order_Master"."ORDNUM_10", "Order_Master"."TYPE_10", "Order_Master"."STATUS_10", "Order_Master"."CUSORD_10"
FROM "GNC5"."dbo"."Order_Master" "Order_Master"
WHERE "Order_Master"."STATUS_10"<'4' AND "Order_Master"."TYPE_10"='MS'
ORDER BY "Order_Master"."CUSORD_10"


\\gnc6\msclose\mscloseonyx.xls
SELECT `Sheet1_`.`startON`, `Sheet1_`.`endOR`
FROM `Sheet1$` `Sheet1_`


It combines both queries and gives me the output and I strap on a query


update GNC5.dbrder_Master set STATUS_10 = '4' where

OR ORDNUM_10 = ' '


I'm trying to get ssis to do all the above steps to streamline the process


I read the flat file in and I can can run the query, but I can get them to do it together. I think once I can get past that part the rest would fall in line.


Thanks!!

 

[philhege]

A bit late here, but you should be able to create a SQL task in your SSIS package that performs the update statement after you read in the flat file.

-----------
With business clients like mine, you'd be better off herding cats.

 

[onyxtacular]

What part of the module would allow me to do that?

 

[philhege]

Are you working with Business Intelligence Development Studio (BIDS) or SQL Server Data Tools (SSDT)? If you're simply using an import wizard you can't design a full-blown package.

In the Designers, you can add tasks to the package that can do any number of things: run scripts, execute SQL statements, etc. etc.

-----------
With business clients like mine, you'd be better off herding cats.