Please provide me information about the use of DTS package and how to create and how to use it.
Waiting for valuable replies
View Complete Post
I am working on SharePoint 2007. I have created 2 List called "Config List" (this is a list) and "Vacation Form" (this is form library & form designed in infopath). I have also created a workflow on form library "Vacation Form"
in Share Point Designer 2007.
With the use of this workflow I am creating some task and updating "Vacation Form".
Now I want to deploy these three thing (Config List, Vacation Form & workflow) on other server.
How do I create a package or WSP file to install these things on different server.
Hello Every One,
I have a scenario in which i am executing a Stored Procedure which returned a result set.
I want to create a Excel file [name_date_time] dynamically, and fill result set data into Excel file. And then finally sent Excel file to Specific user[Email ID].
Point is that the excel file should have unique name so i want to give name as name_date_time.
So every time when package run new file is created with unique name.
Can any one suggest me who to create Excel file and fill result set data into Excel file.
And then finally send that Excel file ?
I've succesfully managed to programmatically create and alter packages, but now I was wondering if it would be possible to do this in a fancy Silverlight 4 application.
Because you can't reference the Microsoft.SQLServer.ManagedDTS.dll assembly in Silverlight, I tried the AutomationFactory.CreateObject("ProgId")
That's where I got stuck. What's the progid, and is this actually possible?
I am an absolutely beginner to SSIS and need to perform the following task.
I know about basic data flow controls etc but I don’t know which control will be better for which task. Please tell me what will be the procedure to fulfill my requirements. I will be extremely thankful.
Syed Afraz Ali
When I don't have master key for AdventureWorks, I still can do this:
CREATE SYMMETRIC KEY Test
WITH ALGORITHM = DES
ENCRYPTION BY PASSWORD = 'abc123.';
What if I create a symmetric key without database master key?
I read MSDN but it doesn't say about this.