Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

flat file <> db , excel <> db , move - copy folder,file and rename in ssis - multiflatfile conncetions Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 8:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 2:58 AM
Points: 4, Visits: 19
Hi all,

I'm new using SSIS.But as i said at topic,had many success tests for these kind of things :

flat file to db or opposite db to flat file.For this title I've made
text to db,db to text,multi text to db,multi csv to db,
rename and move file from one folder to another (using loop container or file task system),
I haven't done exporting many text or csv from a db table.

For excel I searched many sites but usually they're not constructive for people like me.

There was a topic " delete excel file using ssis" something like that.

I've succeed this one,really easy if you think about it for a few time.

Now,I wanna to share these experiences if you want.


Post #1496908
Posted Friday, September 20, 2013 8:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 5,023, Visits: 11,752
kocamisu (9/20/2013)
Hi all,

I'm new using SSIS.But as i said at topic,had many success tests for these kind of things :

flat file to db or opposite db to flat file.For this title I've made
text to db,db to text,multi text to db,multi csv to db,
rename and move file from one folder to another (using loop container or file task system),
I haven't done exporting many text or csv from a db table.

For excel I searched many sites but usually they're not constructive for people like me.

There was a topic " delete excel file using ssis" something like that.

I've succeed this one,really easy if you think about it for a few time.

Now,I wanna to share these experiences if you want.




What is your question?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1496914
Posted Friday, September 20, 2013 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 2:58 AM
Points: 4, Visits: 19
As you see there is no question :)
Post #1496917
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse