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

ssis Expand / Collapse
Author
Message
Posted Thursday, September 24, 2009 3:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 24, 2009 7:00 AM
Points: 1, Visits: 1
ssis

  Post Attachments 
Self-study6.rar (737 views, 9.84 MB)
Post #793123
Posted Thursday, September 24, 2009 3:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:22 AM
Points: 2,728, Visits: 1,119
SQL Server Integration Services

If you need any more info, let us know


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #793124
Posted Friday, September 9, 2011 4:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 5, 2012 11:48 AM
Points: 3, Visits: 6
Hi am new to ssis
can any one provide me good meterial for this cource
Post #1172368
Posted Friday, September 9, 2011 6:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 13,741, Visits: 10,716
You can start here:

http://msdn.microsoft.com/en-us/library/ms169917.aspx




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1172452
Posted Monday, April 16, 2012 5:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 21, 2013 2:41 AM
Points: 5, Visits: 5
Hi Folks,

Need a help, I have a business requirement to genrate a CSV file with following name INDUS_CUST_RM_UPLOAD_20120416_163238.CSV where 20120416 is date in yyyymmdd format and 163238 is time stamp in hhmmss format.

Now the challange is not in generating this file which I am managing quite easily using a BCP command as mentioned below

DECLARE @FileName varchar(100),
@bcpCommand varchar(2000)
SET @FileName ='D:\TalismaImport\Live\WMSRelatedExport\INDUS_CUST_RM_UPLOAD_'+REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 20),'-',''),':',''),' ','_')+'.CSV'
SET @bcpCommand = 'bcp "select CustID,ECN from tlstagingdb.dbo.TempGK_C1FlagRMreport" queryout "'
SET @bcpCommand = @bcpCommand + @FileName + '" -T -c -t ","'
EXEC master..xp_cmdshell @bcpCommand


Now the challange comes in I have to FTP this file to a AIX box.

I am open to using any technology be it ssis or simple windows ftp. Folder containing this file also contains backdataed files.

I tried giving varaible in ssis file connection manager to ftp the file using ftp manager but was unsucessful.

Gave a thought to this and a solution what i have in mind is to insert file name and location in a table while genrating the file (BCP) and then ssis should query that table pickup the file name and path and ftp it to the required location.

Any ideas are welcomed here.

Regards,

Shrey Sheth
Post #1284017
Posted Sunday, October 6, 2013 11:33 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 12:55 AM
Points: 729, Visits: 340
http://dwbi1.wordpress.com/category/ssis/
http://www.mssqltips.com/sql-server-business-intelligence-resources/
http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx
Post #1501933
Posted Monday, October 7, 2013 1:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
Gave a thought to this and a solution what i have in mind is to insert file name and location in a table while genrating the file (BCP) and then ssis should query that table pickup the file name and path and ftp it to the required location.


You can wholly design this logic using a script task using .NET code can do this for you. Also you ca use a combination of Script task to read file name and assign the name to SSIS variable and later use an Execute SQL task to insert values in a table and again use a Script task to FTP the file while reading the file name from a table.


Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1502007
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse