Answer Questions

• C4jun SSIS Import and Export Wizard Data Sources

  I'm just beginning to use SSIS (bracing for a steep learning curve due to lack of helpful documentation) and am starting out trying use the Import and Export Wizard.  On the "Choose a Data Source" page there is a dropdown for the Data Source.  I see a list of possible data providers, but not one of "Microsoft OLE DB Provider for ODBC drivers," which is the one I wanted to use because I'm trying to connect to an obscure databa ...Show All

• Ventuspilot image resource returned in code

  I'm trying to display an image that has been returned from an external assembly, but am having no luck at all. Essentially, I have a utility class that goes to a resource file and pulls out a JPG and returns it. I have set the value property of the image control on the report to hit this assembly, like so : = Code.getLogo() where the function  Code.getLogo() actually interfaces with the utility class. I have tried several variations of th ...Show All

• Buck_Danny Connection

  Hi all, I was on SQL 2000 and now changed over to SQL 2005 Ex Ed. When I run my application I get the following error Mssg @ Conn.Open An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Code: Imports System.Data.SqlClient Public Conn As SqlConnection = New SqlConnection Dim da As New SqlDataAdapter Private Sub Form1_Load(ByVal sender As System.Objec ...Show All

• EdNeo how to design a package with variables so that I can run it by dos command assigning values to variables?

  Hi, I would like to design a SSIS package, which have couple of variables. It loads a xls file specified in a variable [varExcelFileFullPath] . I will run it by commands: exec xp_cmdshell 'dtexec /SQL ....' (pls see an example below). It seems it does not get the values passed in for those variables. I deployed the package to a sql server. are there any grammar errors here I copied it from dtexecui. It worked inside Dtexecui not i ...Show All

• René Cendris Source and Target - Both Behind Firewall using NAT

  In this situation do I need a proxy or forwarder at both ends to prevent connection issues Are there plans to handle this in future SSSB upgrades. Thanks. You don't require a forwarder for this scenario. How does the handshake fail, with what message NAT should not be a reason for connection failure. Can you connect with telnet on the SSB ports from each machine to the other, across NAT HTH, ~ Remus The ...Show All

• Anirudh June CTP - Passing NULL value to a Sub-Report Parameter

  Passing NULL value to a Sub-Report Parameter fails with this message - "A parameter or data source credential is missing a value.  Prompting for this value has been disabled.  Supply a value or enable prompting." Anyone else seen this Thanks I did set 'Allow Nulls' for the parameter. However, this sub-report accepts multiple parms and one of those parm is required and hence I had not set 'Allow ...Show All

• satishpadidem Data Flow execution hangs with no error

  I have a SSIS (CTP June 2005) package with several data flow tasks.  One data flow has 2 OLEDB data sources which are then unioned together, followed by a conditional split, then a derived column transformation, which feeds into an OLEDB destination.  When I run the package, this particular data flow seems to run fine and then just stops.  There are no errors and the records counts don't move.  I've used data viewers to ...Show All

• Tithtlhm Permissions

  The Report Manager will not show on a client machine unless I logon with the local machine administrator account of the report server. The logon credentials that I am using, on the client, is in the administrators group of the local machine of the server. I am only able to author and view reports when physically logged on to the machine with the report server. The same credentials that were used on client machine are used when logging on to ...Show All

• mandoman lookup and commit; How it works

  Lookup and commit; How it works I am importing data from text file and I have data lookup to check reference table. If the reference row doesn't exist I want to add row to reference table, other wise row is added to the detail table. I am using oledb destination to saving reference table row with rows per batch to 1 and maximum insert commit size to 1. When I run the package duplicate rows are in grid view. How can duplicates end in the ...Show All

• Coatesy How to import text file(no space, no symbol, no column) into mssql

   t he text file format use the length of character to define the field for example, 0001130130HAUT BAGES AVEROUS 03 9 chars <0001130130> is a field 1 char <H> is a field 20 chars <AUT BAGES AVEROUS 03> is a field one record by one record store in db no space, no symbol, no line break between each record ---------------------------------------------------------- I try bcp method, but some error happens. Please give me s ...Show All

• rabb List all databases accessible by a login

  Hi all. I am new to SQL-DMO so sorry if what i am asking is really easy. Is it possible to get a list of all objects (including databases) which are accessible for a particular login. So far I have: Dim oSQLServer As SQLDMO.SQLServer Dim oSQLDatabase As SQLDMO.Database Dim oSQLLogin As New SQLDMO.Login Dim oUser As New SQLDMO.User oSQLServer = New SQLDMO.SQLServer oSQLServer.Name = _oSQLServer.Host ' Check se ...Show All

• Evian_ ActiveX Script transformation column in SSIS but how???

  Dear all, I’ve made a SSIS package which might take source columns from a plain text file and copy them to the Sql table. A long time ago, when you did the process I did by dts and that stuff included a pump task which had ActiveX Script transform column with VbScript stuff inside so that, how do I for to do the same with SSIS I’ve got a couple of tasks: Flat File Source and OleDb Source Destination but it’s useless at all f ...Show All

• Dagaen Report Builder load failure on WAN-side of firewall

  All, Can anyone shed some light on this problem: Using the same laptop and credentials I can successfully load Report Builder ONLY from the LAN-side of the firewall. However, if I reconnect using my Sprint AirCard I cannot load Report Builder; I get the now infamous "The remote server returned an error: (401) Unauthorized." What ports are used by Reporting Service Thanks, Brian Does th ...Show All

• David Prentice How to add SQL statements to the package created by Export Data wizard?

  How to add SQl statements to the package created by Export Data wizard I need to add SQL coming from file, the flow would be like this: 1) SQL would drop all objects: (views, tables, stored procedures) etc 2)  SQL would create all objects: (views, tables, stored procedures) etc 3) Export Wizard SSIS package would execute Also is there a dynamic way to add more tables do the package once created in SQL database I w ...Show All

• Zhila Multiple details sections, possible?

  In a table the details section is called "table1_Details_Group". Is it possible to add a second details group so that I can have the two groups have different group properties I'm trying to avoid creating a second table and using an expression to only show one at a time. Again Thanks. possible poss bile poss-bile possibler possibly Edit... Revert to "possbile" thanks. ...Show All