Hi, I am deploying some integration services into a SQL Server 2005. On my computer, I don't have any validation error but I do on the server. It comes from an OLE DB connection manager: "Login failed for user 'rw_user'". Whereas I can fully run it on a client, the connection works perfectly. This is a connection to the server itself....
Hi, When I run my package that has a script component with a reference to my custom assembly, I get this error message 'Could not load file or assembly..' Thanks! ...
I have updated my SQL Server 2008 R2 Evaluation Edition to Enterprise Edition a couple of weeks ago. Service Pack 1 is also installed. Things were going good for a while . But when I run an SSIS package now, I get a Warning: 0x80000036: only 9 days left for evaluation. can anyone help me out in resolving this issue? ...
Hi there, I am trying to load a file using the SQL Server Import Data function - appending rows to an existing table. my existing table is created like this: CREATE TABLE [dbo].[load]( [Long] [varchar](50) NULL, [Lat] [varchar](50) NULL, [Geog] AS ([geography]::STGeomFromText(((('POINT('+[Long])+' ')+[Lat])+')',(4326))) )...
I have a synchronous transformation script component, with some input columns, and an extra defined Output column "ID". ID outputs an integer (DT_I4) type. Under certain circumstances, I would like "ID" to output a null value from my script. Assigning it a null value in other SSIS components works, I can use NULL(DT_I4) within a derive...
I am generating a flat text file via an SSIS package. The package reads data from a table, creates a fixed length text file and ftp's the file to a partner. The data arrives into my table via a process that I have control over so I can make adjustments based on suggestions. My quandry is this. I have a two fields, lets call them: Dat...
I have some large XML files to load via SSIS, and need to get an ID value from the first line of files, in order to get a key value to append to the imported rows: After this root element, there are many children (inidividual elements) which load fine. But when using an XML Task with an XPath query /sessions[1]/@accountId[1], it app...
I have inherited a SSIS package which contains a bulk import task. The bulk import tasks uses the following format file: 8.0 38 1 SQLCHAR 0 2 "" 1 branch_code Latin1_General_CI_AS 2 SQLCHAR 0 10 "" 2 sfkacct_number ...
Anyone know how I can change a SSIS variable at runtime? I have a variable User:SkipStuff I want to set this based on a condition during a for loop container ...
I have a SSIS Data Flow project with a Flat File Source object and a SQL Server Destination object. Is it possible from a C# application to get the inserted rows progress? I haven't found any good info on this. Thanks ...