Showing posts with label save. Show all posts
Showing posts with label save. 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.

Monday, March 19, 2012

How to create a RTF field ?

How can I save the text of a rich text box in a sql express 2005 datatable ?

Of course I'd like to save the string and the format of the text (bold, color etc...).

Which column type I have to use for this RTF field ?

Thank you.

hi,

I'd guess nvarchar(MAX)

this data type can host up to 2gb of text data, in national format thus including chars other than the ones present in the traditional alphabet, like chinese, cyrillic and the like..
http://msdn2.microsoft.com/en-us/library/a1904w6t.aspx
http://msdn2.microsoft.com/en-us/library/ms186939.aspx

http://msdn2.microsoft.com/en-us/library/ms187752.aspx for the complete list of supprted data types..

regards

|||

hi,

Thank you for your response.

In fact, my problem was I directly bind the text property and not the Rtf property of my rich text box to the sql field.

It's strange that the Rtf property is not available for binding in the designer so I have to code the binding !

Me.RichTextBox1.DataBindings.Add(New System.Windows.Forms.Binding("Rtf", Me.TbTextBindingSource, "colText", True))

But now it's working !

regards

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