Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Execute SQL Task
121 results found
SSIS Execute SQL task Error: No disconnected record set is available
SSIS Execute SQL Task Error : No disconnected record set is available for the specified SQL statement. If you get the error in SSIS that says: [Execute SQL Task] Error: Executing the query "INSERT INTO [table].[dbo].[tablename] ([N..." failed with the fol
Author:
MikeDavis
Date: 7/26/2010 Section:
Blog
tags :
Error
,
SQL Task
,
SSIS
Problem with Execute SQL task populating an XML result set
I'm trying to populate an XML result set from an execute sql task which I then use to populate a HTML page. The SQL involved using for xml auto works fine in ssms but I can't get it to work in SSIS 2008. The only clue is that, when I click on build query
Author:
griffster
Date: 4/13/2012 Section:
Forum
tags :
compound statement
,
Execute SQL Task
,
XML
Parameters Don't Always Work in your
Execute SQL Task
Chances are, if you've used SSIS in any capacity, you've used an Execute SQL Task. I would say that about 95% of all the packages I write include at least one. And if you're a fan of making your packages dynamic, chances are you've also probably used the
Author:
kylewalker
Date: 8/5/2011 Section:
Blog
tags :
Execute SQL Task
,
Parameters
,
SSIS
Exit For Each Loop... ?
SchaffnerC, I don't see why you couldn't use a for loop to check for the value of a variable. Call it rolling_number or whatever you want. You could store the current rolling_number variable and you would increment it by what is the current value in the i
Author:
briankmcdonald
Date: 7/5/2012 Section:
Forum
tags :
Brian K McDonald
,
briankmcdonald
,
for each loop
,
For Loop
,
SQLBIGeek
Using SSIS user variables between Script Task and Script Component
That is very strange. I have never seen that behavior. Sounds like a bad install, or I am missing something. Start with a new package and just create one execute sql task that does a select 1 and have the reusults go to a variable. Set the initial value o
Author:
MikeDavis
Date: 1/28/2011 Section:
Forum
tags :
troubleshooting
,
SSIS
Setting Excel Connection Manager connection string dynamically
I have developed an SSIS package (using BIDS 2005) that requires almost everything to be set dynamically; Connections Managers, package variables, SQL statements executed by Execute SQL tasks etc. The reason for this is that the package is designed to be
Author:
lempster
Date: 11/27/2012 Section:
Forum
tags :
connection manager
,
Dynamic Connection Managers
,
Variables
ETL hanging when in transaction
Hi All, Quite new to all this but managed to write an ETL which works prefectly, it extracts 4 flat files and transforms/loads them in to 6 tables. That was until I was told to put it into a transaction that would rollback if anything went wrong - the ide
Author:
steveellis00
Date: 2/27/2013 Section:
Forum
tags :
etl
,
etl tool compare
,
hanging
,
transaction
Override SSIS Package Variables Without Opening the Package
SSIS packages need to have the ability to be dynamic. To an extent we are able to accomplish this through the use of Configuration Files, Execute SQL tasks with results written to variables and even the use of the script task. One great way to make an SSI
Author:
BradSchacht
Date: 8/26/2010 Section:
Blog
tags :
Execute Package
,
SSIS
Using Simple Expressions for
Execute SQL Task
s
Ever have a simple Execute SQL task that you need to modify just slightly over and over again? Like "DELETE FROM myTable". And then you need "DELETE FROM myOtherTable". And also "DELETE FROM yetAnotherTable". And so on. So you create an Execute SQL task,
Author:
stirone
Date: 12/9/2009 Section:
Blog
Delete data
I personally would use an Execute SQL task and pass in the parameter to a stored procedure. However, you don't have to have a stored procedure. You could just pass the paramters in and do something like this. DELETE FROM TableName WHERE ((ColA = ? OR ColA
Author:
briankmcdonald
Date: 9/12/2011 Section:
Forum
tags :
Delete Data
SSIS : Execyte SQL Task
Bhavika, From just reading your question it sounds like you've got a pretty good idea on what the solution is. You'll need an Execute SQL Task to start with (also set an OLEDB connection for your destination environment and an Excel connection for your so
Author:
kylewalker
Date: 3/28/2011 Section:
Forum
tags :
Execute SQL Task
SSIS 2008- Design optimization / Best Practices
Create an Execute SQL Task that truncates each of the tables that you need to reload. Connect the Execute SQL Task to a data flow. Inside the data flow have all of your sources, transform if need be and then let the data flow into their respective destina
Author:
briankmcdonald
Date: 11/4/2010 Section:
Forum
tags :
Loading Data
,
SSIS
size and row count of a table in database in ssis
Use a for each loop on the SMO objects and select the table names as the objects. Map the tabe name to a variable. Then use an Execute SQL task in the for each loop to get the desired from each table. The SQL query will contain a parameter with the table
Author:
MikeDavis
Date: 2/6/2012 Section:
Forum
tags :
loop
Performance thru higher packet size
Hey BIDN'ers, Got some questions about adjusting packet size to the max value for performance gains on package load. My current environment is using a source server, ETL server, and warehouse server. The package resides on the ETL server and moves data fr
Author:
MattDayton
Date: 12/16/2010 Section:
Forum
tags :
packet size
,
SSIS
,
SSIS performance tuning
Encrypting individual columns during data flow using EncryptByKey?
I have a flat file that has columns of data that I want to encrypt when stored in SQL Server, and I'm trying to figure out a way to encrypt the data as it moves through the data flow, rather than loading the data in plain text and then encrypting the data
Author:
andersom79
Date: 11/22/2011 Section:
Forum
tags :
encryption
,
integration services
Using a Merge statement in your SSIS package to update a table
There are many occasions where you will want to update a table in your data warehouse by adding new records and updating existing records. Now, there are a number of ways that this can be done, and these methods all have their pros and cons. The option I'
Author:
kylewalker
Date: 4/28/2010 Section:
Blog
tags :
SSIS
Parent/Child Help
You've got a few options with SSIS. You could "do the work" in T-SQL as an execute SQL task. One method would be modifying something like what is shown here: http://www.sqlservercentral.com/scripts/Miscellaneous/31913/ - I'd use a regular table instead of
Author:
KeithHyer
Date: 5/17/2011 Section:
Forum
tags :
pivot
,
script task destination
,
delimited string
Package Confurations
Hi Dustin, I designed my packages in the following manner plz let me know whether this is write/not My Source and Destinations are SQL Server In control flow as per our company standards i should use execute sql task, purpose of this is to get BatchID, Ma
Author:
veni
Date: 7/5/2010 Section:
Forum
error in execute sql task when updating master table comparing with temp table in SSIS
sqlchicken said: Are you looping through multiple servers when running that code? I've seen issues with temp tables and changing connections in SSIS. Also what's going on "upstream" from this task? When/where does temp table get created? Hi, My Control Fl
Author:
Jahid
Date: 5/17/2012 Section:
Forum
tags :
SSIS Error
Execute SQL Task returning a full result set fails when no results are returned.
I have an execute SQL Task that pulls a recordset in some circumstances, and pulls nothing in other circumstances, this is the desired behavior. When no recordset is returned the task is failing, and the control passes down a failure precedence constraint
Author:
Daniel
Date: 11/27/2012 Section:
Forum
DTS to SSIS 2000 migration - help
Hi paschott, Thanks for the advise, it does help me. I tried to see what these packages do, what I see is the dtspackage consists of mostly Execute Sql tasks which are calling a stored procedure and one ActiveX Task which is using the gloabal variables an
Author:
am35
Date: 2/3/2011 Section:
Forum
error in execute sql task when updating master table comparing with temp table in SSIS
I have separated Matching rows with Lookup and stored the matched data into a temp table through ODLEDB Destination. After finishing data flow task its getting error on Execute SQL Task. Property was set as ResultSet: "NONE"; ConnectionType:"OLEDB"; Conne
Author:
user610781
Date: 5/17/2012 Section:
Forum
tags :
SSIS Error
,
ssis execution
error in execute sql task when updating master table comparing with temp table in SSIS
Jahid said: Hi, My Control Flow sequense is like 1) Execute SQL Task (which creating temp table) - next - 2) Data Flow Task (which transforming data and looking up with existing master data to saperate matching rows. also inserting matching rows into temp
Author:
sqlchicken
Date: 5/17/2012 Section:
Forum
when i run the packeage several times ,the same result will added to the table?how can i achieve this with out adding the result several times to the table?
Hi kiran, one of the option to avoide this problem you can use execute sql task in control flow.by using this execute sql task,truncate the table using "truncate table <TABLE NAME>" .After this excute sql task drag the prescedent constriant to data
Author:
cpraveen70
Date: 4/6/2011 Section:
Forum
Logging in SSIS 2008
You can build your own custom logging by placing tasks in the event handlers of the package. You can use the execute SQL task to write the info to a table. The logging built in to SSIS is limited at best. There is a tool that can do it for you. BIxPress a
Author:
MikeDavis
Date: 2/23/2011 Section:
Forum
tags :
auditing
,
SSIS
Page 1 of 5 (121 items)
<< Prev
1
2
3
4
5
Next >>
Go to page:
[Go]