Showing posts with label saves. Show all posts
Showing posts with label saves. Show all posts

Wednesday, March 28, 2012

How to create or save files in a different domain

Hey,

I have an SSIS package that creates a new file and saves results into that file. However, the requirement has it that I need to create this file on a server residing in a different domain. How can I achieve this in an SSIS package when it is scheduled as a job?

Thanks,

Aravind

When using SQLAgent, you should be aware of permission-related issues like the use of proxy accounts that may come into play. SSIS doesn't have special handling for different domains. For example, if you are using the flat file destination adapter to write data, it will just attempt to write to the file without recognizing where the file is residing. If you are having trouble writing directly to a file in a different domain, it might be easier if you create and write to a file locally using IS (feasibility depending on the size of file) and then copy it over using another mechanism that's proven to work across domains.|||

The obvious method would be to setup a trust between the domains, and just grant permission in the normal way. If that is not an option for you, then the only other method I have used is to manipulate files accross domains is NET USE the old DOS command. You can connect to a share and supply a username and password.

Wednesday, March 7, 2012

How to Create , save DTS in SQL 2005

Can anyone tell me what all steps in creating DTS package , how it saves,

how it re executes... what all steps ... and how it makes?

Thanks

Aravind

SQL Server 2005 has replaced DTS with a new ETL toolset: SQL Server Integration Services, or SSIS.

Are you asking about DTS, or SSIS?

If you're asking about SSIS, then the place to start is here: http://msdn2.microsoft.com/en-us/sql/aa336312.aspx.

As you're probably aware, you're asking questions that it would take several books (and not just a quick forum reply) to answer. Here are these books:

Microsoft SQL Server 2005 Integration Services (SQL Server Series) by Kirk Haselden Professional SQL Server 2005 Integration Services (Programmer to Programmer) by Brian Knight, Allan Mitchell, Darren Green, and Douglas Hinson http://www.amazon.com/s/ref=nb_ss_gw/102-5091542-4864925?url=search-alias%3Daps&field-keywords=ssis