FahimatMicrosoftForum
In Past, I created DTS package on 2000 version, that import TXT file into SQL 2000 table.
Now I migrated the DTS to DTSX (SSIS) package, and all is working fine. but I can not find how can I edit or modify the target table name in DTSX(SSIS) package in BI Studio.
can you some body help.
Thanks
How to change the target table name in SSIS package(not designed from scratch but was migrated)
SQL Server Integration Services
-
- Previous
- 1
- OLE DB Connection Manager will not save password fagster wrote: Thanks for the swift reply. Apologies for not checking the forums sufficiently before posting. Anyway I have the answer now. For anybody else struggling with a similar problem, here is your solution. It involves using XML Package Configurations: http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm It has to be said in my defence that the MSDN help on SSIS makes no mention of potential deployment problems with regard to connection strings and passwords. Nowhere is it made clear that using Package Configurations is the answer AND the password needs to be manually added to the XML after creating the config file. It seems intuitive that the "Save Password" box you tick in when creating the Connection Manager in Visual Studio should do just that, but this is a red herring. This, along with the fact that DTS didn't have such problems, has clearly led to quite a few people getting caught out. Thanks anyway. RichardF Microsoft DOES NOT WANT to be in the business of saving sensitive information. Hence the reason they designed it the way they did. As soon as SSIS touches that config file, you'll find that the password will get removed -- even if you manually entered it. The work around is to set that file to read only, I guess. Saving passwords is generally a bad idea anyway, given other, better means such as single sign-on, pass-through authentication, etc... Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 2
- Cube and aggregation design Check out this BOL page regarding drillthrough setup: http://msdn2.microsoft.com/en-us/library/ms178458.aspx I'd also recommend reading the MS Press SSAS Step-by-Step book. There is a ton of stuff in there that will get you started including a chapter on actions. B. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 3
- accessing static methods of a .net dll, but from sql2000? Is this somehow possible Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 4
- A call to SQL Server Reconciler failed. SQL Server 2005, SQL Server Mobile merge replication Glad that the issue is resolved. I think the user ISUR* did not read permissions on the snapshot folder. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 5
- Data restore help Hi TimDBA, When i tried to attach file, it gave error 5171 (The given file is not a primary database file). As far as I know, it is the primary database file that was restored from data directory of MS SQL server directory. Hope to get your response. Thanks Subasis Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 6
- categories table hi to all; i want to make in my site the possibility for the user to make categories in the site ex: he can add the category name"computer science" and then can add the category childs " data mining, software engineering,... " so firstly i want to make a category table in my databasde to be able to save the category data haw can i make this table i mean what are the columns that should be in the table what type of relationship should i make and how to mahe it sorry but i need any one to explain to me what should i do. and if anyone one know the solution please reply to me thanks.... Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 7
- Could not find stored procedure BTW-I opened a support incident on this problem in 2002, IIRC - the support engineer was Rand Boyd. Hope this helps you to track it. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 8
- How to deploy an report and connection string from some xml file Use an expression based connection and pass your connection string (or components of it) in as parameters. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 9
- Help sorting a Recursive Query Here it is, Create Table #ctlg ( [Data] Varchar ( 100 ) , [ID] int , [Parent] int ); Insert Into #ctlg Values ( 'UndergraduateCatalog' , '1' , '0' ); Insert Into #ctlg Values ( 'History' , '12' , '1' ); Insert Into #ctlg Values ( 'AcademicCalendar' , '14' , '1' ); Insert Into #ctlg Values ( 'FallCalendar' , '20' , '14' ); Insert Into #ctlg Values ( 'WinterCalendar' , '21' , '14' ); Insert Into #ctlg Values ( 'SummerCalendar' , '22' , '14' ); Insert Into #ctlg Values ( 'Preface' , '2' , '1' ); Insert Into #ctlg Values ( 'NonDiscriminationStatement' , '3' , '1' ); Insert Into #ctlg Values ( 'Accreditation' , '4' , '1' ); Insert Into #ctlg Values ( 'Memberships' , '5' , '1' ); Insert Into #ctlg Values ( 'MissionStatement' , '8' , '1' ); WITH tree ( data , id , level , pathstr , sortkey ) AS ( SELECT [Data] , [ID] , 0 , CAST ( [Data] AS NVARCHAR ( MAX )), CAST ( 10000000 + [ID] AS NVARCHAR ( MAX )) FROM #CTLG WHERE [Parent] = 0 UNION ALL SELECT V . [Data] , V . [ID] , t . level + 1 , t . pathstr + '>' + V . [Data] , CAST ( t . sortkey + CAST ( 10000000 + V . [ID] AS NVARCHAR ( MAX )) AS NVARCHAR ( MAX )) FROM #CTLG V INNER JOIN tree t ON t . id = V . [Parent] ) SELECT data , id , level , pathstr FROM tree order By sortkey Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 10
- "Select * from Table" is processed much faster than "Select MyField from Table" ???? Tell us what happens when you change your SELECT * in your Exists statements to SELECT 1. My hunch is that you either have bad stats and it is trying to use an index that it has to lookup the key, or that the * is throwing the optimizer off in the return query so that the completely wrong index is being used, or no index is being used. Let us know the results of the above. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 11
- Usage Based Optimization - Problem If you right click on the server and choose properties you will see it on one of the tabs. Look for a small box with a label like "enable query logging". This is from my memory. Regards Thomas Ivarsson Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 12
- DTS problem on 64-bit installation Is there solution of the DTS problem for Vista 64-bit The one below doesn¡¯t work for 64-bit installation. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 13
- Can I change from Integrated Security? When creating my database, I initially set it up to use Integrated Security (Windows Login), however I am having a hard time logging into the database on a consistent basis using this method. Can I now change to a specified user id and password How would I do that Would I lose any data in my database Does the user id and password need to be the same user id and password used when logging into SQL Server Thank you. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 14
- Remove SP1 or install SP2 Dec. CTP Ah! there is a hotfix addressing this very issue. I will try it. http://support.microsoft.com/Default.aspx id=919478 Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 15
- Insert Identity value with SqlCeResultSet Hi I have a table with an identity column. This is set to increase by 1 and start on 1, and is the first column of the table. When I insert a record into the resultset, I get an error stating that it can't be DbNull. Th record is created from a resultset with the query "Select * from table", so the id should be included But as I understand it, it should be increasing automatically, right Becuase that's the behaviour of the normal sql Insert command. I have seen an article that just left the id column in the record alone before inserting it, but it didn't help me. How can I sidestep this issue Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 16
- Add Reference to Excel in Scripting tool in SSIS 2005 How can I add a reference to the Microsoft excel 2003 in the script tool in SSIS 2005 I need to automate Excel for formatting. Thank you. Dan Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 1
- Next
- 1
- Inconsistency between Data Source Designer and underlying code Turns out the problem was this: the project was checked out by the person who created the datasources. When he checked the datasources in, he did NOT check the project back in. The project's definition contained the incorrect connection strings. Once the project was checked in, that issue was resolved. Thanks for your responses. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 2
- SQL Server 2005 Express Is there no way in SQL Server Management Studio 2005 Express (SSMSE) to migrate the data only to an already provisioned database on another server Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 3
- Increase Transaction Log size Hi, How can I increase the transaction log size of my sql server 2005 database i can execute the shrink and backup log which can shrink the .ldf file to 1MB. However, since my dts involves a lot of inserts and updates, the my transaction log grows to 700MB in the middle of my dts execution. How can i increase the transaction log size maximum capacity to probably 1.5GB just so it can accommodate my full dts execution BTW, this is my commands to shrink the log file: DBCC SHRINKFILE ( <dbname>_log , 1 ) BACKUP LOG <dbname> WITH NO_LOG DBCC SHRINKFILE ( <dbname>_log , 1 ) cherriesh Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 4
- top 10 accounts for every day with summary hi, i am new to mdx and stuck on a problem on analysis services 2005. there is an orders cube with calendar and accounts dimension. the report i want to do is something like this date account quantity top10percentage 01.01.2007 All 1000 85 bnm 230 23 abc 150 15 bbc 140 14 aaa 100 10 wer 60 6 rrr 40 4 xyz 35 3,5 xtv 35 3,5 tyu 30 3 tbh 30 3 02.01.2007 All 1230 75 abc 150 15 bnm 150 15 bbc 140 14 aaa 100 10 txp 60 6 rrr 40 4 xyz 30 3 xtv 30 3 tyu 25 2,5 tbh 25 2,5 i have written a calculated member for the percentage of the account for that day's total order amount. but when i do a filter on accounts dimension to get top 10 records for that day in excel 2007 the total value of the percentage for that day remains 100. not the sum of the top 10 records percentage values. i am looking a way to write a report like this and appreciate any suggestions. and also any workaround to solve this excel behaviour. thanks in advance Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 5
- Improving Performance kk, what is bcp or DTS remeber i said i wasn't familar enough with Sql and the inserts are parameterized and well i'm not sure some of that time is getting the event entries remotely... but's it's not the upload that is bothering me... it's the performance when i try to query for information. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 6
- Copy objects with DTS Import/Export Wizard? I also share in their frustrations... When you only have a few objects, in this case tables to transfer; you have very little options in the SQL2005 Import/Export wizard as compared to the SQL2000 DTS (Import/Export) wizard. Copy Database is out of the question for this scenario. My problem lies in the fact that the SQL2005 Import/Export wizard does not create the indexes and keys when the table needs to be created in the target database, even if the source schema exists on the target database. Is there any way around this without pre-creating the target tables from scripts generated on the source DB Seems that this manual step should be built into the wizard Ay suggestions We are running SP2 for SQL 2005. There are suggestions that SSIS can be used, thats fine, but given the entirely different interface as compared to DTS, I don't have the time to deal with that when the wizard should be able to do this in a few minutes. Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 7
- Problem with the SQL Insert with .CommandText() and .ExecuteNonQuery() Hi I think I have found the problem the database connection i set to. The database in my project folder is the one that is appearing on my IDE's server explorer. But the program was actually inserting data to /bin/debug/database.mdf instead. That is the reason why I am unable to see the data in my database. How can I make my debug binary point to the same working database instance, than to create mulitple copy of the database Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 8
- Select Statement In Table (Valid Expressions Error). here's the solution with the function that i've mentioned a while ago you can get the Split Function here Code Snippet CREATE FUNCTION dbo.ParseAccountNo ( @AccountNo varchar(800) ) RETURNS varchar(800) AS BEGIN DECLARE @SelectStmt varchar(800) SET @SelectStmt = '' -- for & delimiter IF (SELECT COUNT(*) FROM dbo.Split(@AccountNo,'&',NULL,NULL)) > 1 BEGIN SELECT @SelectStmt = @SelectStmt + 'AccountNo LIKE ''%' + RTRIM(LTRIM(CSV)) + ''' OR ' FROM dbo.Split(@AccountNo,'&',NULL,NULL) END -- for , delimiter ELSE IF (SELECT COUNT(*) FROM dbo.Split(@AccountNo,',',NULL,NULL)) > 1 BEGIN SELECT @SelectStmt = @SelectStmt + 'AccountNo LIKE ''%' + RTRIM(LTRIM(CSV)) + ''' OR ' FROM dbo.Split(@AccountNo,',',NULL,NULL) END -- you can insert other delimiter here -- -- for single account no ELSE BEGIN SELECT @SelectStmt = @SelectStmt + 'AccountNo LIKE ''%' + @AccountNo + ''' OR ' END IF @SelectStmt <> '' SET @SelectStmt = LEFT(@SelectStmt,LEN(@SelectStmt) - 2) SET @SelectStmt = 'And (' + LTRIM(RTRIM(@SelectStmt)) + ')' RETURN @SelectStmt END your optimized proc would then be.. INSERT INTO dbo.New_Cust_Table SELECT [Name] + '1' AS UserId , [Name] + '1#' AS Pwd , dbo.ParseAccountNo(AccountNo) AS SelectStmt FROM Cust_Table Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 9
- Why does using the "in" clause cause an error in my "Having" condition in 2000, but not 2005? Hmm..guess giving the error might help: Column 'Business_Grp.GLUnitCode' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause. I modified the SQL I posted to try to strip out the "real" database names ( didn't do a good job of that, did I ). Regardless, I know how to make it work. The SQL is coming out of my BI system (auto-generated), I'm just tyring to determine if its a BI problem or a MSSQL problem. The fact that it works in SQL 2005 suggests that this is a bug in SQL2000 (which means logging it with Microsoft). Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 10
- Dose anybody knows how to use MergeJoin component programitcally? I'm building a package programitcally and I can't find any document which shows how to work with MergeJoin component in code. Please help, Thanks Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 11
- SQL Server 2005 SP2 cannot be installed because the Database Engine setup remains in suspended installation mode SP2 refuses to install for the Database Engine because ¡°the previous upgrade did not complete¡±, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine. When I try to do the same thing this time, I¡¯m presented with the ¡±complete the suspended installation¡± option, which when I run it reports the installation completed successfully. However, in reality the installation still remains in suspended mode for whatever reason. If I reboot and open the maintenance dialog, I¡¯m still presented with the ¡±complete the suspended installation¡± option. I¡¯ve even tried to run it more than once, but it doesn¡¯t help. Needless to say, SP2 still refuses to install. I don't know why the installation is in a suspended state. I know every part of SP1 installed successfully in the end, and the computer never crashed during the installation. I've been using it every day since then, without any problems. All other parts of SP2 did install successfully. I created a feedback entry on Microsoft Connect, where you can find the log files created by Windows Installer. The URL is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=259606 Any ideas what I can do to resolve this problem Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 12
- patindex with nvarchar so please give me solution as possible, here i have written my stored procedure as below which use above function:--- I am using for all column nvarchar only in which i stored hindi text and English as well. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO -- -- spSearch -- SUMMARY Executes a search using the specified query -- PARAMS @siteId Identifier of the site from which the search request was generated -- @query Full-text query to be executed against the full-text engine -- ALTER PROCEDURE spSearch ( @siteId INT, @textOnly BIT, @query NVARCHAR(4000) ) AS -- Select Alternatives Declare @partialQuery NVARCHAR(50) Declare @keyphrase NVARCHAR(50) --Query can be provided like 'searchterm' or as "search term" depending in existance of space character --must format the partial query if it contains a space like '"search term*"' --the keyphrase is @query without quotes IF CHARINDEX('"',@query) > 0 BEGIN SET @partialQuery = LEFT(@query, LEN(@query) - 1) + '*"' SET @keyphrase = LEFT(RIGHT(@query, LEN(@query) - 1), LEN(@query) - 2) END ELSE BEGIN --must format the partial query like '"searchterm*"' set @partialQuery = ' "' + @query + '*" ' set @keyphrase = @query END --Now we can search for alternatives as exact match of @query on alternatives --or partial match on keyword, but ignore exact match on keyword (i.e. only alternatives to @query) SELECT * FROM tblKeywords WHERE NOT Keyword = @keyphrase AND SiteId = @siteId AND ( CONTAINS(Keyword, @partialQuery ) ) -- Select the pages that match the query SELECT DISTINCT c.ContentName, c.ContentLongSummary, c.MasterId, nc.NavigationId FROM tblContents AS c INNER JOIN trelKeywords AS ck ON ck.MasterId = c.MasterId INNER JOIN tblKeywords AS k ON k.KeywordId = ck.KeywordId INNER JOIN trelNavigationContents AS nc ON nc.MasterId = c.MasterId INNER JOIN GetKeywordsFromQuery(@query) AS kq ON kq.Word = k.Keyword INNER JOIN tblNavigation AS nav ON nc.NavigationId = nav.NavigationId WHERE c.SiteId = @siteId AND c.StatusID = 2 AND c.DeletedBy IS NULL AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) UNION -- the following selects list pages that match, with primarylist page as their navigationid SELECT DISTINCT c.ContentName, c.ContentLongSummary, c.MasterId, nc.NavigationId FROM tblContents AS c INNER JOIN trelKeywords AS ck ON ck.MasterId = c.MasterId INNER JOIN tblKeywords AS k ON k.KeywordId = ck.KeywordId INNER JOIN tblContents AS c1 ON c.PrimaryListMasterId = c1.MasterId INNER JOIN trelNavigationContents AS nc ON nc.MasterId = c1.MasterId INNER JOIN GetKeywordsFromQuery(@query) AS kq ON kq.Word = k.Keyword INNER JOIN tblNavigation AS nav ON nc.NavigationId = nav.NavigationId INNER JOIN tblListContents AS lst ON lst.ListItemMasterId = c.MasterId WHERE c.SiteId = @siteId AND c.DeletedBy IS NULL AND c.StatusID = 2 AND c1.statusid = 2 AND c1.DeletedBy IS NULL AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) AND lst.ContentMasterId = c.PrimaryListMasterId -- Select the downloads that match the query SELECT DISTINCT r.ResourceId, r.ResourceName, r.ResourceLongSummary, r.FileSize FROM tblResources AS r INNER JOIN trelKeywordResources AS kr ON kr.ResourceId = r.ResourceId INNER JOIN tblKeywords AS k ON k.KeywordId = kr.KeywordId INNER JOIN GetKeywordsFromQuery(@query) AS kq ON kq.Word = k.Keyword INNER JOIN trelContentItemResources AS cir ON r.ResourceId = cir.ResourceId WHERE r.ResourceTypeId = 2 AND r.SiteId = @siteId AND cir.StatusId = 2 SELECT CASE WHEN nc.MasterId IS NULL THEN cir.MasterId ELSE nc.MasterId END AS MasterId, CASE WHEN nc.MasterId IS NULL THEN ln.NavigationId ELSE nc.NavigationId END AS NavigationId, c.ContentName, res.ResourceId, res.ResourceTextType, res.ResourceText, c.ContentLongSummary FROM tblResources res INNER JOIN trelContentItemResources cir ON cir.ResourceId = res.ResourceId LEFT OUTER JOIN trelNavigationContents nc ON nc.MasterId = cir.MasterId LEFT OUTER JOIN tblContents c ON c.MasterId = cir.MasterId AND c.StatusId = cir.StatusId LEFT OUTER JOIN trelNavigationContents ln ON c.PrimaryListMasterId = ln.MasterId LEFT OUTER JOIN tblNavigation nav ON nc.NavigationId = nav.NavigationId INNER JOIN tlkpResourceTypes rt ON rt.ResourceTypeId = res.ResourceTypeId INNER JOIN tblListContents AS lst ON lst.ListItemMasterId = c.MasterId WHERE (res.SiteId = @siteId) AND (res.ResourceTypeId = 1 OR res.ResourceTypeId = 6) AND CONTAINS(res.ResourceText, @query) AND (c.ContentPublicationDate IS NOT NULL) AND (c.DeletedBy IS NULL) AND (c.StatusId = 2) AND (nc.MasterId IS NOT NULL) AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) OR (res.SiteId = @siteId) AND (res.ResourceTypeId = 1 OR res.ResourceTypeId = 6) AND CONTAINS(res.ResourceText, @query) AND (c.ContentPublicationDate IS NOT NULL) AND (c.DeletedBy IS NULL) AND (c.StatusId = 2) AND (c.PrimaryListMasterId IS NOT NULL) AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) ORDER BY rt.SearchResultOrder, c.ContentName GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 13
- MDX Ranking Question Hi A further question to this. We are also wanting to make this ranking Time aware. Currently, you can only run the quesry for a specific time period (eg [dimDate].[Year].[2006]). If you try to create a crossjoin in the report to have all the above measures by 2005 and 2006, then the ranking does not work anymore. As far as I understand it, this will be the case as the Order Set does not know about the time dimension, and hasn't ordered the Products by Time. So, how I see this is that I will need to add the time Dim to the order Set, but at what level. We would like to make this dynamic within the cube and would like the ranking to work in a year on year, quarter on quarter, month on month ...etc level. I would think that ordering by the lowest level of time (day in my case) might work, but would create a set that is extremely large. Would this work, or is there a better way to do this Michael Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 14
- BCP loading failing on timeout error Hi Paul, are you using Cognos 7.2 - The bcp delivery in 7.2 will create a temporary text file in default data directory, there for make sure you have enough disk space. .... Which version of SQL-Server and SP are you running Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 15
- allows blank value for integer Parameter Hi have a problem to solve and I hope that this is not a SSRS Bug. I created a Reports(using SQL Server Project) which has several parameters which values are passed to a SP. One of these parameter is an Integer and it is an optional value, so if the user fill it is used by the SP, otherwise the SP uses NULL and run anyway. I starts to define tha parameter: Datatype = integer Allow blank value Available: Non queried Default: Null if I want to Preview the report I have to provide an integer to the parameter's field ... If for instance I set: Default: Not queried = 0 In the moment I deploy and I use the ReportViewer in my window application the parameter's field is unabled!! So I tried this solution: Datatype = integer Allow blank value Allow null value Available: Non queried Default: Null In the preview the checkbox: NULL is checked and I click on the View Report. But when I deploy it,in the ReportViewer in my window application the parameter's field this checkbox is unchecked. Do I forget something during my setting I have to control it programmatically N.B. By default the user will not user this parameter so the best is that he can click directly on "View Report" without any additional "work" on the parameter!! Thank you for any help! Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 16
- No one can help me on this prolem?????? Have you tried to leverage the cascading parameter feature WHat if you change the EmployeeDS dataset to have a clause like: WHERE EmployeeID IN (@ParameterThatYouPassFromTheWebApp) The @ParameterThatYouPassFromTheWebApp must precede the related parameters in the Report Parameters dialog box. Will this do the trick HTH, Jordi Tag: How to change the target table name in SSIS package(not designed from scratch but was migrated)
- 1
- Previous
Re: How to change the target table name in SSIS package(not designed from scratch but was migrated)
jwelch
Can you tell us what tasks the package has in it
If it has a data flow, there should be a destination component in it. One of the properties of the destination component will be either the table name or a variable that holds the table name.
Re: How to change the target table name in SSIS package(not designed from scratch but was migrated)
FahimatMicrosoftForum
it does not show any data flow task. all it show is the connection managers, one is for txt file, and one is for database. I can see all properties of soruce file but in destination, i can only server and database name, but there is no place where I can change the table name too.
Thanks,
it does not show any data flow task. all it show is the connection managers, one is for txt file, and one is for database. I can see all properties of soruce file but in destination, i can only server and database name, but there is no place where I can change the table name too.
Thanks,
Re: How to change the target table name in SSIS package(not designed from scratch but was migrated)
Phil Brammer
What tasks DOES it show
FahimatMicrosoftForum wrote:
it does not show any data flow task. all it show is the connection managers, one is for txt file, and one is for database. I can see all properties of soruce file but in destination, i can only server and database name, but there is no place where I can change the table name too.
Thanks,
What tasks DOES it show
Re: How to change the target table name in SSIS package(not designed from scratch but was migrated)
jwelch
What tasks are in the package
What tasks are in the package
Re: How to change the target table name in SSIS package(not designed from scratch but was migrated)
FahimatMicrosoftForum
When i succesfully migrated it from DTS to SSIS. it shows taks as "Execute DTS 2000 Package Task" in control flow tab. and at bottom it shows two connection manger , one for my Source TXT file, and one for destination SQL Server database.
and what I am looking for editing Destination parameters.
Thanks,
When i succesfully migrated it from DTS to SSIS. it shows taks as "Execute DTS 2000 Package Task" in control flow tab. and at bottom it shows two connection manger , one for my Source TXT file, and one for destination SQL Server database.
and what I am looking for editing Destination parameters.
Thanks,
Re: How to change the target table name in SSIS package(not designed from scratch but was migrated)
jwelch
It's still using the DTS package - that's what the Execute DTS 2000 Package Task is. So you'd have to open the DTS package to change the destination table. You'll need the DTS Designer components from the SQL 2005 Feature pack to edit the DTS package.
You might want to look at truly converting it to run natively under SSIS.
Re: How to change the target table name in SSIS package(not designed from scratch but was migrated)
FahimatMicrosoftForum
you are right, that was i was thinking, I am downloading now the MSSQL 2005 backward compatibility components to see if it helps. i hope it does not break anything else.
DTS 2000 was simpler to work as compared to SSIS, but SSIS indeed brings more features (
).
Thanks for being with me so far.
you are right, that was i was thinking, I am downloading now the MSSQL 2005 backward compatibility components to see if it helps. i hope it does not break anything else.
DTS 2000 was simpler to work as compared to SSIS, but SSIS indeed brings more features (
).Thanks for being with me so far.