Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: i Can't generate my transact SQL to run ETL system

    like This...?

    select @cmd = 'dtexec /DTS "\File System\Financial_ETL_System\ETL_OLTP_STG_Fact_ProjCal" /SERVER [10.30.62.48]'

    select @cmd = @cmd + '/CONNECTION "10.1.2.91.CK_DWHS.dev";"\"Data Source=10.1.2.91;User ID=XXX;password=XXXX;'

    select @cmd = @cmd + 'Initial Catalog=CK_DWHS;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False; '

    select @cmd =...

    March 24, 2011 at 8:50 pm

    #1303332

Viewing post 1 (of 2 total)