SSIS File exist check without script task
- by Pramodtech
Is there any way to check if file exist without script task? May be foreach loop container or something else..
Search Results
Search found 794 results on 32 pages for 'ssis'.
Page 12/32 | < Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19 | Next Page >
-
-
SSIS send mail task error out specified string not in form req for an email address
- by Pramodtech
My send mail task works fine for email ids like user@mydomain.com but it throws error for email ids like user@subdomain.mydomain.com. is there any way i can make it work for such ids also? Thanks.Read the article
-
ssis flat file source trim blank spaces
- by Pramodtech
Is there any way i can trim the blank spaces when I read data from CSV file? Thanks.Read the article
-
How to parse a date from an SSIS Excel filename
- by user327045
I want to use the foreach container to iterate through a folder matching something like: "Filename_MMYYYY.xls". That's easy enough to do; but I can't seem to find a way to parse the MMYYYY from the filename and add it to a variable (or something) that i can use as a lookup field for my DimDate table. It seems possible with a flat file data…Read the article
-
Table Variables in SSIS
- by aceinthehole
In one SQL Task can I create a table variable DELCARE @TableVar TABLE (...) Then in another SQL Task or DataSource destination and select or insert into the table variable? The other option I have considered is using a Temp Table. CREATE TABLE #TempTable (...) I would prefer to use Table Variable so that it remains in memory. But can…Read the article
-
SSIS Expressions - EvaluateAsExpression Problem
- by Randy Minder
In a Data Flow, I have an Derived Column task. In the expression for one of the columns, I have the following expression: [siteid] == "100" ? "1101" : [siteid] == "110" ? "1001" : [siteid] == "120" ? "2101" : [siteid] == "140" ? "1102" : [siteid] == "210" ? "2001" : [siteid] == "310" ? "3001" : [siteid] This works just fine. However, I…Read the article
-
Return Integer value from SSIS execute SQL Task
- by Bokhari
I am using SQL Server 2005 Business Intelligence Studio and struggling with returning an integer value from a very simple execute SQL Task. For a very simple test, I wrote the SQL Statement as: Select 35 As 'TotalRecords' Then, I specified ResultSet as ResultName = TotalRecords and VariableName = User::TotalRecords When I execute…Read the article
-
CSV is not creating format problems with integer value when generated through SSIS package
- by paranjai
Hi I am trying to generate a CSV file from DB Query as source one of my column is having datatype nvarchar(50) with values as "01050007029604301001" After the export when the csv file is viewed using Excel the value appears as "1.0500E18" . How can i stop this . Please suggestRead the article
-
SSIS with different table structures
- by Grace
I have a flat file source from Excel that has a structure like this: **People** Day1 Day2 Day3 Day4 Person1 someValue ... Person2 Person3 And i would like the package to put this information in a database with standard columns 'Person', 'Day', 'Value'. Does anybody know how to do this - at…Read the article
-
SSIS Script Component + Helper Assemblies (.dll's)
- by Nev_Rahd
I got a script component which does Transformation / DataType conversions / Creating some calculated columns. All the transform validations / datatype conversion methods and for new column generation is put into custom .dll. As this script component would be same for all other tables, only thing is to define input / ouput columns and…Read the article
-
Exception Handling in SSIS Script Task
- by Sreejesh Kumar
Is it possible to redirect the Exceptions occurred to another table/log, in Script Task ? If so, How is it to be done ?Read the article
-
Weird SSIS Configuration Error
- by Christopher House
I ran into an interesting SSIS issue that I thought I'd share in hopes that it may save someone from bruising their head after repeatedly banging it on the desk like I did. I was trying to setup what I believe is referred to as "indirect configuration" in SSIS. This is where you store your…Read the article
-
SSIS Technique to Remove/Skip Trailer and/or Bad Data Row in a Flat File
- by Compudicted
I noticed that the question on how to skip or bypass a trailer record or a badly formatted/empty row in a SSIS package keeps coming back on the MSDN SSIS Forum. I tried to figure out the reason why and after an extensive search inside the forum and outside it on the entire Web (using several search engines) I indeed found…Read the article
-
SSIS - Parallel Execution of Tasks - How efficient is it?
- by Randy Minder
I am building an SSIS package that will contain dozens of Sequence tasks. Each Sequence task will contain three tasks. One to truncate a destination table and remove indexes on the table, another to import data from a source table, and a third to add back indexes to the destination table. My question is this. I currently…Read the article
-
SSIS package in SQL Server 2005 can send data to SQL Server 2008?
- by needshelp
Hi SSIS Geniuses, I Have an SSIS package in SQL Server 2005 that takes data from a flat file and puts it in a table in SQL Server 2005. Now I want it to send it to an additional location along with the 2005 location. This new table is in SQL Server 2008. Can it be done without porting my SSIS package to SQL Server 2008? …Read the article
-
How do I change the server name destination dynamically on a SSIS?
- by lborge
Hi, I have a SSIS that should be execute since the server and invoke since a client. The SSIS copies the data from the server to the client, but the client's name can change, so how can I change the server name destination with the name of the client that invokes the SSIS? Thanks!!!Read the article
-
SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor
- by pinaldave
Microsoft SSIS Balanced Data Distributor (BDD) is a new SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading. The transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion. It’s…Read the article
-
StreamInsight/SSIS Integration White Paper
- by Roman Schindlauer
This has been tweeted all over the place, but we still want to give it proper attention here in our blog: SSIS (SQL Server Integration Service) is widely used by today’s customers to transform data from different sources and load into a SQL Server data warehouse or other targets. StreamInsight can process large amount…Read the article
-
Semi-blocking Transformations in SQL Server Integration Services SSIS
In a SSIS data flow, there are multiple types of transformations. On one hand you have synchronous and asynchronous transformations, but on the other hand you have non-blocking, semi-blocking and fully-blocking components. In this tip, Koen Verbeeck takes a closer look on the performance impact of semi-blocking…Read the article
-
How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2
when you create a data source in SSRS 2008 R2 (Nov CTP), you won't be able to get SSIS listed as a data source type. Therefore applications that are already using it as a data source or applications that require it as a data source get stuck. Let's learn how to enable and get SSIS listed back as a data source…Read the article
-
Red Gate join the SSIS custom component club
I recently noticed that Red Gate have launched themselves into the SSIS component market by releasing a new Data Cleanser component, albeit in beta for now. It seems to be quite a simple component, bringing together several features that you can find elsewhere, but with a suitable level polish that you’d…Read the article
-
Run an SSIS Package Under a Different Account
In this article, learn how to use the SQL Server agent proxy to run an SSIS Package under whatever account you choose.Read the article
-
SSIS 2008 Configuration Settings Handling Logic for Variables Visualized
- by Compudicted
There are many articles discussing the specifics of how the configuration settings are applied including the differences between SSIS 2005 and 2008 version implementations, however this topic keeps resurfacing on MSDN’s SSIS Forum. I thought it could be useful to cover the logic aspect visually. Below is a…Read the article
-
Load and Execute SSIS Packages in Microsoft Windows with a Demo WPF Application
This article introduces a method to load and execute SSIS packages in Microsoft Windows with a demo WPF applicationRead the article
-
My Favourite Two Buttons in Denali CTP1 SSIS
In SSIS for SQL Server 2005 and SQL Server 2008 when you delete something from the design surface it is gone. The only real way of getting the deleted item(s) back is to revert to a previous version of the package or to redo the deleted items manually. Neither of these options is particularly…Read the article
