Answer Questions

• Chrischik Regenerating Package ID programmatically

  Hi, I built a small application that helps me create new packages by loading a template and modifying some parameters, and eventually save the updated package to a user defined location. This application uses the SSIS programming API. I know all the packages created this way from the same template will have the same package ID. Is there a way to regenerate the package ID programmatically I don't want to use dtutil.exe, but rather a nice pa ...Show All

• Tbonehwd How to Deploy .mdf Files

  Hi Guys, I have a problam. I wanna deploy my application that it has data.mdf file. When I install and test it I get this message: --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '42000' SQL Server Error: 5133 [Microsoft][SQL Native Client][SQL Server]Directory lookup for the file "C:\Program Files\MyDic\Database\Data.mdf" failed with the operating system error 5(Access is ...Show All

• nuclearfusion Execute SSIS package without SSIS console

  Hello, How can i do to execute SSIS package without SSIS console This can occur when you use a hosted database with your hosted web. thanks Hi, I'm not quite sure what you mean by the SSIS console. Packages can be executed using DTExec - a command line execution tool. You can also execute packages from managed code. Does this help -Jamie There might be some performance difference due to different reporting, but for most packa ...Show All

• Will Walter what i forgot

  hideho mates, well could it be.... all SQL services r runnin, i created 2 sql logins with ALL rights!!!!! well now i want to use one of this accounts (which r domain admins too) too install VSTFS 2005 Beta 2...so far so good...but the first evetnlog entry after the begin of the install is always "sql server login failed - cannoct connect to the database"... the funny thing is > AFTER is event log entry ALL VSFTFS and ADAM Databases gonna  ...Show All

• njf Need a task that will zip a file prior to upload via FTP

  I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this Thanks.     Duane Douglas wrote: you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx SiteID=68 Thanks.  I posted the suggestion. Cool, thanks. I'll be looking for it ...Show All

• darth_dan Configuration for Configuration Package? Is this Possible?

  Hi Guys, Here's the current scenario: I am creating a windows application to manage my ssis packages. My SSIS packages use package configurations, and by default connect to the "SSIS Configurations" table in sql server. However, I want it to connect to a view instead of this table, so i create a view "vwSSIS_Configurations" and point the package configuration to use the view in sql server. T ...Show All

• Sherif Mahmoud SSIS Foreach loop stress testing problem.

  I am currently working on a project which needs to load over a 1000 xml files. The files are stored across 10 subfolders. I am using a foreach loop with a file enumerator, which is configured at the top of the folder structure and traverses the subfolders. This loops through the files, load the data and then moves the file to another folder. The package executes fine for a few 100 files but then hangs; this happens after a different number of ...Show All

• kissinger AMO based C# application: Pre-requisites

  Hi, Okay I am finally done with my AMO application in C#. Here is a brief on what it tries to accomplish: It Creates/synchronizes an existing Oracle OLAP datawarehouse into SSAS. This is done using AMO in C#. I programatically create Dimensions, Cubes, MeasureGroups, Measures,Partitions, Update the DataSourceView and its table references. Finally I process the Cubes. This application is scheduled, where it picks up a list of entities t ...Show All

• juan carlos ceresola Moving the ReportServer database

  I want to move the ReportServer database .mdf and .ldf files from the default directory to another drive (E:) The ReportServer service is started, but when I run a sp_help_db from SQL Server management studio the ReportServer database is not listed. When I tried to detach it using sp_detach_db , the command reported succes but I'm wondering how this worked when the database is not in the sysdatabases table. I haven't tried moving the Repor ...Show All

• Martijnvl Keyboard not working (backspace and arrow keys) when viewing 2000 DTS packages from 2005 (backward compatibility)

  I know my problem is not directly associated w/ SSIS, so please forgive the post here. I figured this would be the "most" appropriate place to post this challenge. We're attempting to edit a 2000 DTS package in Design mode from within the 2005 SQL Management Studio. To do this we downloaded/installed the following packages from the MS download site: Microsoft SQL Server 2000 DTS Designer Components Microsoft SQL Server 2005 Bac ...Show All

• Anwar Javed SqlBulkCopy in .NET 2.0

  I am trying to insert large volume of data into sql server tables. I am not sure whether to go with traditional method of generating the load files and use BCP command or go with the new SqlBulkCopy class introduced in .NET 2.0. My main concern is performance and can anyone recommend the best solution Thanks Ah, BCP and SqlBulkCopy are basically the same in most respects. SqlBulkCopy expects to read a ...Show All

• beechy34 The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• Timothyjb Encryption and recovery on standby machine

  Hi there, to follow on my question in the other forum, I have a database with triple des encrypted columns Master key created, certificate and symmetric key using certificate. Values inserted into table (encrypted) Can select etc, all works fine. Back up and restore database on another server, decrypting the data results in NULLs being returned. Backed up and restore the master key, cerficate, etc but either it completes successfully ...Show All

• Inamori Passing parameter to a dts

  I don't understand how to pass a parameter to a dts package from another. In SQL 2000 you can map a variable with a variable of the package you will call. How can I do this For example in the current package execution (package1) I have a variable1 = 5 and when some step complete I call package2 with the value of variable1 in variable2 of package2. I need help with this. Thanks in advance.   KirkHa ...Show All

• k_samsonov auto-increment nvarchar column

  Hi experts! The situation :I have a table containing the MemberID and related member's info. The MemberID is the pk and should be incremented for every new member. However, the ID is in "nvarchar" type, since it consists of an "IM" prefix. I used the following stored procedure to insert new member to the table. CREATE PROCEDURE dbo.spInsertNewMember @parMemberTitle nvarchar(2), @parMemberFirstName nvarchar(40), @parMem ...Show All