Accessing variables using file connection in Execute SQL Task

SQL Server Documentation

Index ‹ SQL Server
- Archive
  - Visual Studio
  - Windows Live
  - Smart Device
  - Windows Forms
  - VB
  - VS 2008
  - Visual C#
  - Office
  - ISV
  - IE
  - Windows Vista
  - VS Express
  - VC++
  - SQL Server
  - Dotnet
  - Architecture
  - SharePoint
  - Game
  - VFP

- Previous
  - 1
    - Newbie Parameter Problem Hi, I have 3 parameters on my form. StartDate (datetime), EndDate (datetime) and CompanyName(string). The default values are: StartDate (Non-queried) 1-1-2005, EndDate (Non-queried) 1-1-2008, CompanyName (From query) DataSetBelow, Value field (AccountFamily): SELECT DISTINCT AccountFamily FROM CallDataRecords The table on the form contains the following DataSet: SELECT Salutation, InboundTimeMS, OutboundTimeMS, ModifiedOn, IsRightParty, AccountFamily FROM CallDataRecords WHERE AccountFamily = @CompanyName AND ModifiedOn BETWEEN @StartDate AND @EndDate The error I get is: "Query execution failed for data set (one directly above)". "Must declare the scalar variable "@CompanyName". Can anybody shed light please Thanks, Dan Tag: Accessing variables using file connection in Execute SQL Task
  - 2
    - Backup Database HI i have created job which executes following Store Procedure, my Qs is after 1-day has passed shldnt it overwrite , i mean i have 1-GB Database my job runs for 3-times a day so end of day i have 3-GB so wen time goes past 12.00 am shldnt it becomes 1-GB again Alter Procedure sp_DBBackup as BACKUP DATABASE [XYZ] TO DISK = N'D:\Office Purpose\Database\Backups\XYZ\Backup-Method (Append-Expiry)\XYZ_Complete_Append.Bak' WITH NOINIT , NOUNLOAD , RETAINDAYS = 1, NAME = N'XYZ backup', NOSKIP , STATS = 10, NOFORMAT Tag: Accessing variables using file connection in Execute SQL Task
  - 3
    - RESTORE DATABASE I need to restore a database. I have never done it before. I get an error on this command: Syntax Error. What is wrong with it RESTORE DATABASE [intraDay] FROM DISK = 'J:\SqlServerBackUps\IntraDay\intraDayFullRM.BAK' WITH RECOVERY , TO 'C:\intraDay.mdf' ; -- this is just to try the RESTORE in principle. I will restore the DB to a different folder. GO Thanks. Tag: Accessing variables using file connection in Execute SQL Task
  - 4
    - problem with recursive cte query I am running into 2 problems with this cte query. First off, it's not returning the results in the right order. What I mean is that, as you can see from the graph, the first row (tabid=4) should be followed by rows 3,4 and 5 but it's throwing in a row between. No matter how I try and order the results, it's not working as it should. The tabindex field is a user defined field as to what order the tabs should show up for the user so I have to order by that field at some point. ParentTabId TabId Title Link TabIndex 1 4 Personal Info /Employee/employeeAdmin.aspx 1 1 5 Employment Info /Employee/positionInfo.aspx 2 4 8 Dependents /Employee/dependents.aspx 3 4 169 Emergency Contacts /Employee/Contacts.aspx 2 4 170 Demographics /Employee/EmployeeAdmin.aspx 1 1 172 Employment Files /Employee/empFiles.aspx 3 172 210 New Hire Paperwork /Employee/empFiles.aspx 1 172 211 Form I-9 /Employee/I9.aspx 2 172 212 General /Employee/employment.aspx 3 172 213 Notes /Employee/notes.aspx 4 172 214 Pre-Employment /Employee/preemployment.aspx 5 172 217 Protected Health Information /Employee/protectedhealth.aspx 6 1 220 View All /Employee/viewAll.aspx 4 Problem 2 is that I need to format all of this as heirarchal xml but when I output it as xml in the query itself, every element is coming through as MainTabs (the cte name) instead of nesting rows 3,4 & 5 under tab id 4. So, how do I (if it's even possible) fix these two things If I can't do this in a query, how would you suggest getting an xml formatted result set from a table structure like this Structure meaning parenttabid = tabid of another row ordered by the tabid and then tabindex Thanks. with MainTabs(ParentTabId, TabId, Title, Link, tabindex) as ( select ParentTabId, TabId, Title, Link, tabindex from Tabs where parenttabid = 1 UNION ALL select t.ParentTabId, t.TabId, t.Title, t.Link, t.tabindex from Tabs t inner join MainTabs on MainTabs.TabId = t.ParentTabId ) select ParentTabId, TabId, Title, Link, tabindex from MainTabs order by tabid, tabindex Tag: Accessing variables using file connection in Execute SQL Task
  - 5
    - Request for feedback - Aliases have been deprecated for some time and will be removed soon As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release. We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine Tag: Accessing variables using file connection in Execute SQL Task
  - 6
    - Help with cupe partitioning/processing Hello guys I have an issue with one of our cubes which i hoped someone could help me with... The problem is a historical cube which is currently growing quite drastically, and includes daily history from 2004 until today. The cube is just processed full every single day, and this means processing 80+ million rows every day, when actually most of the data is not changed at all. I decided I want to split my cube in data for 2004, 2005, 2006, 2007 and then the current month. Once the current month is over then i would merge it with the year to date partition and create a new partition for the new month. My problem is how to implement the processing in a simple way Right now the processing is done in SSIS by just processing full the db, so I guessed i have to make 2 tasks, one to process full all the dimensions first , and one to process full the cubes afterwards in which i process for this specific cube only the latest partition. But this means at the end of the month I would have to change the package manually, since i need to merge some partitions and then process full only the newest partition again... Is there any simpler way of doing this Is my approach correct in the partitioning way and processing full of only the newest partition, except at the end of the month when i would need to merge and process the ytd partition Tag: Accessing variables using file connection in Execute SQL Task
  - 7
    - Problem running SSIS from C# have one script that works fine. I am doing the exact same thging with this new script and it runs fine from C# on my desktop and runs fine from SS on the server but comes back with a failure when trying to run from C# on the server. Is there any additional info I can retrieve about the problem All I am getting right now is "Failure" from the result field. if (result == DTSExecResult .Failure) { Console .WriteLine( "Task failed or abended" ); log.Error( "Problem with DTS Script" ); log.Error(result); } else Tag: Accessing variables using file connection in Execute SQL Task
  - 8
    - MDX Sum distinct across specific dimensions I have a measure group that has a few measures that are not addittive across all dimensions. I need to be able to get the sum distinct across specific dimensions and am having problems getting it to work. I tried specifying that the aggregate function should be semiaddittive, but it complains that it is missing a time dimension. I have tried many variations and combinations of MDX functions including sum, aggregate, crossjoin, filter, distinct, etc. but am struggling with the right combination. Here is a simplified example of what I am trying to do: GroupID Title Role ConditionCount 11682 Director Operations Licensing Manager 2 11683 Director Operations Licensing Manager 3 11683 Director Operations Product Manager 3 When I group on role I need to see this: Licensing Manager 5 Production Manager 3 When I group on Title, I need to see this: Director Operations 5 Basically I want to do a sum distinct for the GroupID. I only want to add the ConditionCount once for each distinct GroupID since the value will be the same for all instances of an individual groupID. Is there a way to do this in MDX Thanks in advance for your suggestions! Clayton Tag: Accessing variables using file connection in Execute SQL Task
  - 9
    - OleDB Source and Parameters Hi, Firtsly - I am new to SSIS if my approach could be improved then I welcome suggestions. Scenario : I have a large SSIS package that consolidates / summarizes work week information from several data sources. Currently each data flow task in the control flow calculates the from and to date that is filtered on, for example: DECLARE @FromDT AS DATETIME SET @FromDT = CAST(FLOOR( CAST( DATEADD(D, -7, GETDATE()) AS FLOAT ) ) AS DATETIME) DECLARE @ToDT AS DATETIME SET @ToDT = CAST(FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME) I would like to remove these statements that appear in most steps and replace them with a global variable that is used throughout the package. This statement would only appear once & it would make the package much easier to run after failure etc. Problem: I am using Data Reader Source with the 'SQLCommand' property specified. It looks like parameters are only supported if an OleDB connection is used So I switched to an OleDB connection and no parameters are recognised in the string - a forum search reveals that parameters in sub queries are not always found properly. The solution to this problem appears to be, to set 'Bypass Prepare' to True but this is a property for the Execute SQL task, not the Data Flow Task source. Questions: Does the Data Reader Source control from Data Flow Source toolbox section support parameters Can anyone suggest a fix to the OleDB Source issue with Parameters Is there a better way to solve my problem e.g. Using Execute SQL Task instead of Data Flow tasks etc Example SQL: This SQL is an example of the SQL for the OleDB Data Source (within a Data Flow task) ------------------------------ --RADIUS LOGINS ------------------------------ DECLARE @FromDT AS DATETIME SET @FromDT = CAST(FLOOR( CAST( DATEADD(D, -7, GETDATE()) AS FLOAT ) ) AS DATETIME) DECLARE @ToDT AS DATETIME SET @ToDT = CAST(FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME) DECLARE @Attempts AS BIGINT SET @Attempts = (SELECT COUNT(*) FROM dbo.Radius_Login_Records WHERE LoggedAt BETWEEN @FromDT AND @ToDT) DECLARE @Failures AS BIGINT SET @Failures = (SELECT COUNT(*) FROM dbo.Radius_Login_Records WHERE LoggedAt BETWEEN @FromDT AND @ToDT AND Authen_Failure_Code IS NOT NULL) DECLARE @Successes AS BIGINT SET @Successes = @Attempts - @Failures DECLARE @OcaV1Hits AS BIGINT SET @OcaV1Hits = (SELECT COUNT(DISTINCT LoginName) FROM dbo.Radius_Login_Records WHERE LoggedAt BETWEEN @FromDT AND @ToDT AND EAPTypeID = 25) DECLARE @OcaV2Hits AS BIGINT SET @OcaV2Hits = (SELECT COUNT(DISTINCT LoginName) AS OcaV2Hits FROM dbo.Radius_Login_Records WHERE LoggedAt BETWEEN @FromDT AND @ToDT AND EAPTypeID = 13) SELECT @Attempts AS ConnectionAttempts, @Failures AS ConnectionFailures, (CAST(@Successes AS DECIMAL(38,2)) / CAST(@Attempts AS FLOAT) * 100) AS SuccessRate, @OcaV1Hits AS OcaV1Hits, @OcaV2Hits AS OcaV2Hits Please remember, I'm new to SSIS - so be detailed in your response. Thanks for your help! Tag: Accessing variables using file connection in Execute SQL Task
  - 10
    - searching similar records within a table Hi, I have 4 tables : Code Block Create Table #Request ( [requestid] int , [stateno] nvarchar ( 5 ) , [cityno] int , Callid int , UniqueNo int ); Create Table #RequestDetail ( reqdetailid int , [customername] Varchar ( 20 ), [customerage] int , requestid int ); Create Table #Call ( Callid int , Calltype int , callDetailid int ) Create Table #CallDetail ( callDetailId int , empid int ) Insert into #CallDetail VALUES ( 12123 , 1 ) Insert into #CallDetail VALUES ( 53423 , 1 ) Insert into #CallDetail VALUES ( 6532 , 1 ) Insert into #CallDetail VALUES ( 82323 , 1 ) Insert into #CallDetail VALUES ( 124235 , 1 ) Insert Into #Call VALUES ( 111 , 1 , 12123 ) Insert Into #Call VALUES ( 112 , 1 , 53423 ) Insert Into #Call VALUES ( 114 , 1 , 6532 ) Insert Into #Call VALUES ( 123 , 2 , 6532 ) Insert Into #Call VALUES ( 134 , 1 , 124235 ) Insert Into #request Values ( '324234' , 'SA023' , 12 , 111 , 0 ); Insert Into #request Values ( '223452' , 'SA023' , 12 , 112 , 0 ); Insert Into #request Values ( '456456' , 'SA024' , 12 , 114 , 0 ); Insert Into #request Values ( '22322362' , 'SA024' , 44 , 123 , 0 ); Insert Into #request Values ( '22654392' , 'SA023' , 12 , 134 , 0 ); Insert into #requestdetail values ( 1 , 'Bill' , 23 , '324234' ) Insert into #requestdetail values ( 2 , 'Tom' , 25 , '223452' ) Insert into #requestdetail values ( 3 , 'Bobby' , 27 , '456456' ) Insert into #requestdetail values ( 4 , 'Guck' , 29 , '22322362' ) Insert into #requestdetail values ( 5 , 'Bobby' , 33 , '22654392' ) 1. My stored proc will take the CallDetailID. 2. I have to find out the requests made on this calldetail. 3. After getting the request, i want to take the Customername, cityno of the request/requestdetail and pass it again to #request table to search for any duplicates within the request. 4. If found return the details of the original record : [A similar requirement was solved earlier, but the structure has changed. This is a seperate requirement with different table strucure. Hence a new post. ] thanks Tag: Accessing variables using file connection in Execute SQL Task
  - 11
    - How to Create Assembly function using dll files in SQL Server 2005??? Hiiiiiiii all I have to make a user defined function in c# as the class liberary and create a dll file, now i want to use this function in SQL Server 2005 as a part of CLR Integration I have tried like this CREATE ASSEMBLY abc FROM 'C:\abc.dll' WITH PERMISSION_SET = SAFE but it gives me incorrect syntax error so plzzzzz anyone help me wht to do in my probbbbbbbbb Pratik Kansara Tag: Accessing variables using file connection in Execute SQL Task
  - 12
    - Database user and Corresponding login Hi everyone, I have a simple question regarding the database users on sqlserver 2005. When i run a 'sp_helpuser' stored procedure in a database to know the usernames and their corresponding loginsName, i find there are some usernames with corresponding loginName as null.I know for sure that for 'Guest' username the corresponding loginName will be Null, but i find many normal database users with Null login names. Can anyone throw some light on this scenario .and what about 'dbo' user in a database can dbo user have a 'NULL' login name or 'sa' login by default . Please help me Thanks in advance. Regards Arvind L Tag: Accessing variables using file connection in Execute SQL Task
  - 13
    - Error while changing Custom Resolver between 2005 Publisher and 2000 Subscriber Hi all, here is the context of our problem: - Publisher : version SQL Server 2005 SP2 table in SQL Server 2000 (80) compatibility level publication in SQL Server 2000 compatibility level - Distributor : SQL Server 2005 SP2 - Subscriber : SQL Server 2000 SP4 + hotfixes (version 8.00.2187) There is only one article in our publication (a simple table with a GUID and a nvarchar(50) columns), and we have left the default resolver. 1 - The first synchronization of the subscription is successfully completed, and it is the same for the different updates/inserts/deletes or conflicts. 2 - Then we change the Resolver of our article by our own COM-Based Custom Resolver (developped in C# 2.0). This resolver only change the default behaviour: the subscriber always win (this is for a test, in the future we will have a complex business logic). All the synchronizations works fine and do what we want in the conflicts. 3 - We rollback the resolver to the default one... and here is the problem! The synchonizations stop to work correctly. For all of them we've got the same error: Code Snippet Replprov.dll , 2007/09/25 14:26:07.591, 4000, 16890, S1, ERROR: ErrNo = 0x80045017, ErrSrc = <null>, ErrType = 8, ErrStr = The schema script ' declare @cmd nvarchar(1000) set @cmd='exec sys.sp_MSchangearticleresolver @article_resolver=@ar, @resolver_clsid=@rc, @artid=@ai, @resolver_info=@ri' exec dbo.sp_executesql @cmd, N'@ar> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie..." mailto:N @ar">N'@armailto:N'@ar">N'@ar</A< A>> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie... It is no more possible to synchronize this subscription... Any remark will be helpfull cause we did not find anything on the net concerning this error. Thanks a lot! Tag: Accessing variables using file connection in Execute SQL Task
  - 14
    - Question on Row Count Transformation Hi all, i'm using Row Count Transformation downloaded from http://www.sqlis.com/93.aspx to generate surrogate key. in my data flow, i have OLE Data Source connected to Row Count Transformation connected to SCD. i've configured ok and the package ran without error. my problem is my surrogate key column won't generate the next increment number if i run the package the 2nd time and there is new row in the dimension, e.g. Id BusinessKey BusinessName --- ------------------ --------------------- 1 RDO Radio 2 MAG Magazine 3 TV Television 1 INT Internet } added new row from source did i miss something please help. thanks. Tag: Accessing variables using file connection in Execute SQL Task
  - 15
    - SQL Server SP2 Command Line Upgrade Switch and Express Version Detection Our application installation setup needs to be able to detect: Is SQL Server 2005 Express Installed If false, run the SP2 Installation Is SQL Server 2005 Express or SQL Express SP1 Installed If false, run the SP2 Installation with Update Switch Is SQL Server 2005 (not Express) Installed If true, abort installation with a mesage. Can you direct me to some documentation about testing for these environments or just if someone has some scripts that will run in InstallShield, that would be great. ALSO, can you direct me to information about using the command line update switch for the Express SP2 Installer Thanks. Pat Tag: Accessing variables using file connection in Execute SQL Task
  - 16
    - Datetime format for dimension Please help me Dear All, How can I format a dimesion datetime column . for example while browsing a cube, the value of the dimension column 'DateOrder' shows like that 2002-11-01 00:00:00. I wan to get 01/11/2002 dd/mm/yyyy. What I have to do. When I changed their cell value property as dd/mm/yyyy it doesnpt working ..Please to crrect my problem with regards Polachah Tag: Accessing variables using file connection in Execute SQL Task
- Next
  - 1
    - Custom Assembly Security Hello Everyone, When I run my report from report manager, I get the following error message Failed to load expression host assembly. Details: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. My report uses a custom assembly. I have already done the following 1. copied the assembly in the "reportserver\bin" and the "common 7\privateassemblies" area 2. Made the following entry in the rssrvpolicy.config <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="RSUtil.TranslationHelper" Description="Translation Helper Utility"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\ReportServer\bin\AMOTest.dll" /> </CodeGroup> 3. Added the following line to my assemblyinfo.cs file [assembly: AllowPartiallyTrustedCallers] regards, Abhishek. Tag: Accessing variables using file connection in Execute SQL Task
  - 2
    - inflation factor in Analysis Services 2005 Anybody knows how to apply an inflation factor depending on the date to a measure in Analysis Services 2005 The Inflation Factor is (Current Month Rate / X Month Rate) So lets say for current year the rates are Jan 121.64 Feb 121.98 March 122.244 April 122.171 For example If I want to calculate for March I would show a column for January February and March, the column for January would be multiplied by (122.244/121.64) the column for February would be multiplied by (122.244/121.98) and march by one (122.244/122.244) But in April the factors would be different I would have 4 columns, January February March and April, January amounts would be multiplied by (122.171/121.64) February by (122.171/121.98) March by (122.171/122.244) and April by one (122.171/122.171) Im using SSAS 2005 Thanks in advance Isaac Tag: Accessing variables using file connection in Execute SQL Task
  - 3
    - Error I am getting the following error "An error occured during local report processing.Error during processing of 'Validate' report parameter " Any idea about this error Tag: Accessing variables using file connection in Execute SQL Task
  - 4
    - Advice on dimension-dependant KPI Goals We have KPI goals that vary based on the country or state. For instance for US Stores, the goal is 2, and for stores in NY the goal is 2.8 I can create an SQL table with KPI_Name, Country or State, and KPI_Goal. I can also generate a view that will provide the proper KPI goal for each store. What is the best practice to implement this kind of KPI I just don't know where to start. The examples I've seen are all hardcoded, like CASE when Store = XXX then 2.8 I'd rather avoid hardcoding KPI goals in the cube design as I'm expecting users to adjust goals regularily. Tag: Accessing variables using file connection in Execute SQL Task
  - 5
    - Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out We are running on SQL Server 2005 SP2. Merge replication is on for one publisher and one subscriber. Merge replication is throwing following error "The process is waiting for a response from the query '{call sys.sp_MSmakegeneration ( )}" It is hung on there for atleast couple hour or so. I decrease uploadbatches and downloadbatches settings as recommended but no positive results. Let us know if any insight on the above issue. Thanks Tag: Accessing variables using file connection in Execute SQL Task
  - 6
    - Moving ReportServer Databases Followed the steps in Books Online to move the Reporting Services databases from one server to another. After resetting all the keys and configurations, the site comes up. However, all my shared datasources have lost their connection strings, and have reverted to requesting login information. Is this how it is supposed to work If not, how do I fix this easily (as I have about 25 data sources) Tag: Accessing variables using file connection in Execute SQL Task
  - 7
    - Table Join For 1 Dimension I have table join like this: Table A Table B _________ _________ | SVC_ID | ---------- | SVC_ID | |_________| |_POS | |_________| Table A is the primary table that contains every SVC_ID available. Table B will link to the SVC_ID in the Table A. Table B will not have duplicate SVC_ID's, and will not have every SVC_ID that is in the Table A. Now, my dimension is based off of Table A. I simply want to add the POS field as an attribute (showing up as Unknown/NULL when the SVC_ID doesn't exist.) The problem is that doing so limits the rows returned from Table A (only SVC_ID's that are in Table B). I tried reversing the relationship in the DSV, but AS will throw and error when trying to process. I also set the KeyNotFound setting to Ignore for the dimension. The only way I get this to work is to make a completely new dimension for Table B. Is that necessary Is there a way I can use the Table B POS field as attribute for Table A Thanks! Tag: Accessing variables using file connection in Execute SQL Task
  - 8
    - Hiding Non Empty Dimension members when using pivot tables I am working with a snowflake-type schema and I have a regular dimension that is joined to a fact table with a couple thousand unique members that represent financial instruments. I then have a reference dimension table with about 20 unique members that represent credit quality of these instruments. The typical presentation of this data is going to show the aggregated facts over this credit quality dimension but I would like to provide the ability to drill down into each credit quality sector to see the relevant instruments and their facts. When I nest the instrument dimension below credit quailty in a pivot table, it appears that I always get a full crossjoin (all of the two sets when I am really after something like a non empty crossjoin. Any suggestions would be appreciated. Tag: Accessing variables using file connection in Execute SQL Task
  - 9
    - some questions about SMK The <Protect Sensitive Data Using Encryption in SQL Server 2005> said : If regenerate service master key with "FORCE" option, the keys protected by old service master key are lost forever along with the data encrypted by them. I create a master key in database and create a certificate protected by it.Then i use the certificate to encrypt some data. The master key also exists and the encrypted data can by decrypt after i regenertate the SMK with force option. So i'm puzzled,I want to know what are the keys which protected by SMK , are they database master key thanks Tag: Accessing variables using file connection in Execute SQL Task
  - 10
    - Automate backup for SQL 2005 I am very new to SQL 2005. I need to automate backup for the SQL server which can take backup of all databases from the server at fixed time without using third party backup system. Thank you for help. Tag: Accessing variables using file connection in Execute SQL Task
  - 11
    - Cannot create a custom task I've gone through all the steps, and when I finally drag the custom task I've made into the control flow, I get the error "Failed to create the task. ... Cannot create a task with the name "SSISExportToExcel.ExcelExport.ExcelExport, SSISExcelExport, ... Verify the name is correct" Here's the beginning of my class... any help would be appreciated... Namespace ExcelExport <DtsTask(DisplayName:="Excel Export Task", _ Description:="Exports a SQL query results to an Excel Document")> _ Public Class ExcelExport Inherits Task .... Tag: Accessing variables using file connection in Execute SQL Task
  - 12
    - multi-value parameter in Master report passing to single param sub-report in a list. Here's tricky one. I have a fairly complex report that was given to me that was hard coded for single parameters. There is a dropdown for each market (created from a query in SSRS). The users have to run for each market each week. Is there a way to use this report as a Sub-report inside a list of a master report and then use a mult-value parameter I want this multi-value parameter to build the values for the list and then run the "sub-report" for each value. Essentially, I want to create a for each loop. Any ideas Tag: Accessing variables using file connection in Execute SQL Task
  - 13
    - Shared datasource in different folder... Hi all, Ive tried searching but nothing came up specific to my problem. I currently have all the reports separated into separate folders, such as Finance, HR etc, and the datasources in a datasources folder at the root level. My problem is that when i upload reports into their appropriate folder, the shared datasource information gets deleted, and i need to re-map it everytime. Is there anyway to have the specific reports point to specific shared datasource folders on the report server when i upload them cheers Rob. Tag: Accessing variables using file connection in Execute SQL Task
  - 14
    - SQL 2005 EXPRESS & ORACLE 10g Hi all, I am trying to link Oracle 10g (32bit) to SQL 2005 Express. My environment is: -SQL 2005 Express & Oracle 10g run to Windows 2000 - Oracle client is installed to the server I use either "New linked server" from Management studio or I run sp_addlinkedsever & sp_addlinkedsrvlogin to add the new oracle server. The server is succesfully created under "Linked servers" without any error. The point is I do not find the Oracle tables from within Management studio. Do I miss any step I tried both Microsoft & Oracle OLE DB, but i failed To the same server is also installed SQL 2000. From within Enterprise manager I linked Oracle 10g database without any error. Also I see the tables and run select statements. I used both Microsoft & Oracle OLE DB. Can anybody help Tag: Accessing variables using file connection in Execute SQL Task
  - 15
    - sql server agent service failure Hi all, I'm new to sql server administration so please show some understanding! I installed sql server 2000 personal edition (upgrated to sp4) on an windows xp pro OS, but I cannot get the sql server agent service running. I get a message " the service did not start due to a logon failure". The server is my local pc , I'm using windows authentication and the login is "domain/loginname" where domain is my pc name. Does it have to be installed on a server OS to have this service running Thanks George Tag: Accessing variables using file connection in Execute SQL Task
  - 16
    - Tell Us Your Express Story and Win $100! Want a chance to show off a cool way you��re using Visual Studio Express or SQL Server Express We��re looking for your stories! Tell us about something that makes your life easier or is just plain fun and if we like it enough to include in a feature article, we��ll give you a $100 gift certificate to Amazon.com! http://msdn.microsoft.com/vstudio/express/support/hero_promotion/default.aspx Tag: Accessing variables using file connection in Execute SQL Task

Yongpil

Hi there,

I need some help on how to access variables using a file connection... if that's not possible even direct input.

I made a variable for the server name, and now I only need to know how to call the variable in the script.

any help is appreciated. thanks

Top

Re: Accessing variables using file connection in Execute SQL Task

Yongpil

anyone...

Top

Re: Accessing variables using file connection in Execute SQL Task

Arnie Rowland

You need to provide more information -it is not clear what you are attempting to accomplish.

Also, there is the system variable @@Servername -it will ALWAYS provide the name of the current attached server.

Top

Re: Accessing variables using file connection in Execute SQL Task

Yongpil

In a package I created, I have several Execute SQL Tasks. each Execute SQL Task brings in a script using file connection (SQLSourceType).

So what I need to do is to make several copies of that package.. let's say 10.

and let's say in one package there are 10 execute sql tasks. which means 10 scripts.

so the problem is each of the 10 packages have to use the same scripts but it is connecting to a different server name. So I was wondering if I could make variables for the server names, then I only need 10 scripts (it would be 100 if I make scripts for each sql tasks, 10 packages * 10 sql tasks) cuz I can just use a variable to specify the server names.

whoa.. confusing but I hope this helps you to understand me better.

Thanks,

Top