Post reply

ssis

  • September 24, 2009 at 3:21 am

    #215613

    ssis

  • September 24, 2009 at 3:23 am

    #1057913

    SQL Server Integration Services

    If you need any more info, let us know 😀

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • September 9, 2011 at 4:09 am

    #1379097

    Hi am new to ssis

    can any one provide me good meterial for this cource

  • September 9, 2011 at 6:37 am

    #1379168

    You can start here:

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

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 16, 2012 at 5:21 am

    #1473948

    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

  • October 6, 2013 at 11:33 am

    #1656171

    http://dwbi1.wordpress.com/category/ssis/

    http://www.mssqltips.com/sql-server-business-intelligence-resources/

    http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx

  • October 7, 2013 at 1:30 am

    #1656231

    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.

    Raunak J

  • March 30, 2015 at 11:39 pm

    #1787561

    Help required on below error,

    1. Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager " scan.IEDB" failed with error code 0xC0202009. There may be error messages posted before this with more informatino on

    2. Why the AcquireConnection method call failed

    3. Error: component " OLE DB Source" (2042) failed validation and returned error code 0xC020801C.

    4. Error: One or more component failed validation

    5. Error: There were errors during task validation.

    6. Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured. Error Code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'release'.".

  • March 31, 2015 at 6:00 am

    #1787651

    narasimhan 89525 (3/30/2015)

    "Login failed for user 'release'.".

    Seems pretty darn obvious to me...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 9 posts - 1 through 8 (of 8 total)

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