tidal with SSIS

[coool_sweet1]

hi

i need to schedule my ssis using tidal,

i dont know what parameter i need to pass to command.

after seeing other packages they are passing .exe file, my question is do i need to create this file,whats purpose of this file and how can i create it.

i have 1 parameter in my ssis package

[coool_sweet1]

what i have is following commnad for tidal to run ssis job.

        Jobname: 01_product

·         Program command:  c:\Applications\SQLJob\SQLJob.exe

·         Program command parameters: Server=dayssis01  I=20 Job = Product

·         Capture Alternate Output File: 

·         Schedule: AD HOC

·         Run Agent: day-05

·         Runtime user: local

my question is what is  c:\Applications\SQLJob\SQLJob.exe

here and how to create and use it.

i have my package in 2012

[Dinesh Sankaranarayanan]

Sorry that does not ring a bell. My guess is that either

1. The requester of the job has created a custom .exe that you can invoke. So I would suggest you login to the server your windows agent is planned to run, and confirm if c:\Applications\SQLJob\SQLJob.exe exists on that server

OR

2. The requester may not be aware that Tidal can invoke SSIS jobs using 3 other options(command line or stored procedure or SQL job). You may need to educate the requester and obtain updated command to trigger specfic SSIS job using any of the 3 alternatives

[vamsivaliveti.edu1]

@Dave.Carnahan

I am referring attachment png file beginning with the name 'DOS.xxx' and i have below doubts.Input will be appreciated

1)Could you please provide details and code for what i need to mention in 01_Tidal_Env.Bat file and also where i need to place this file

2)What is SSID.DtsConfig and where this file is present?

[rocketscientist1]

Hi Coool_sweet,

One way you could do this is as follows:

1.  create a job on a windows agent

2.  command:  cmd.exe

3.  parameter:  /C \\path\to\batch\file.bat

4.  file.bat file contains something like this:

@ECHO OFF

DTEXEC.exe /FILE "\\path\to\file.dtsx" /argument1 /argument2

where:

a) your dtsx file is an integration services package you can create/edit with Microsoft Visual Studio

b) /arguments are optional depending on the package you have created