MIgrating Existing WorkFlow Data using SSIS

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Using full text search with keywords from a column Hi all I am trying to find a solution for using a full text search from a keyword column. The scenario is email subscription service, where the users specify keyword as a subscription parameter. The desire is to get all subscription data in one select statement. To see what I am trying to do please look at the example below: SELECT * FROM SubscriberTable st INNER JOIN DataTable dt ON {Some Condition} WHERE CONTAINS (dt.TextColumn, st.KeywordColumn) Any help is greatly appreciated Regards, Salavat Akhmediev Tag: MIgrating Existing WorkFlow Data using SSIS
  - 2
    - Top 10 Chart grouped by Month Hello, I have a bar chart that I need to show the top 10 items by Month. What I get currently is a chart by month with the total Top 10 Items (rather than the top 10 per month). I have tried adding a scope onto my Value expression but that didn't help. =countDistinct(Fields!incident_ref.Value, "catGrpDate") Please Help! Tag: MIgrating Existing WorkFlow Data using SSIS
  - 3
    - IIF and multi-valued parameters sluugy & Shyam thx for this - should have posted an answer as i had already realised about vb evaluating the whole expression in IIF and written the function as described thx m Tag: MIgrating Existing WorkFlow Data using SSIS
  - 4
    - Keep TableRow Together Hey Marco, Did you fix your problem I have an identical one and I would like to know if you could solved. Please share your solution with me, it will be very much appreciated. Ioan Cozma Tag: MIgrating Existing WorkFlow Data using SSIS
  - 5
    - howt to change ConnectionString in Context Just define another SQLConenction object with the new connection string. new SQLConnection("Data Source...andsoon") HTH , Jens K . Suessmeyer . --- http :// www . sqlserver2005 . de --- Tag: MIgrating Existing WorkFlow Data using SSIS
  - 6
    - How do I manage this mess? Thanks! But would this actually copy the rest of the record into EmployeeAll, i.e., the records that only showed up in the old employee table (the employees terminated before the conversion took place) or the records that only showed up on the new employee table (i.e., the employees hired after the conversion was completed) Thanks! Regards, Anyi Arnie Rowland wrote: I thinks that something like this is what you want: Code Snippet -- This collects the data INSERT INTO EmployeeAll SELECT n.EmployeeID, n.LastName, n.FirstName, n.DateOfBirth, coalesce( o.HiringDate, n.HiringDate ), coalesce( o.TerminationDate, n.TerminationDate ), n.{RemainingColumns} FROM NewEmployees n LEFT JOIN OldEmployees o ON ( n.LastName = o.LastName AND n.FirstName = o.FirstName AND n.DateOfBirth = o.DateOfBirth ) Tag: MIgrating Existing WorkFlow Data using SSIS
  - 7
    - sql server 2005 express also i was wondering, that i have been reading that with this sp2 for sql server 2005 express you are able to use the dts wizard, is this true i have a few databases in access that i would like to import into sql, would i have to create the tables first in sql then import or will the import also bring the tables & structure in thank you to all Tag: MIgrating Existing WorkFlow Data using SSIS
  - 8
    - LEFT JOINING two INNER JOINS You have been offered, and seem to reject a reasonable solution. And since you know about using a derived table as Kent mentioned, and since you also clearly know that your code as posted does work exactly like you hoped, What is the question Tag: MIgrating Existing WorkFlow Data using SSIS
  - 9
    - index replication from DB2 If you take a look at sp_addarticle at its @schema_option, there is option to set for primary key constraint. http://msdn2.microsoft.com/en-us/library/ms173857.aspx If you look at the default schema option for all the log based article type 0x80 are enabled for all of them. I think this article is the closest I can think of. I'm pretty sure, it's on by default. Also a quick test probably won't hurt, just create a simple table with two integer columns and make the first column the primary key, then replicate to db2. Seeing is believing :-) Gary Tag: MIgrating Existing WorkFlow Data using SSIS
  - 10
    - Flat file to table - rows out of order Not to sound mean or anything, but Jamie is absolutely right. There is no such thing as ordering in database land. Just because your experience "proves" otherwise, doesn't make it fact. The only way to guarantee order is to use an ORDER BY clause on your SQL statement which only controls the PRESENTATION of the data, not the way it's stored. Do you have a situation that the records are out of order when ordering by an identity column, or are you merely using a "select * from table" statement without an ORDER BY clause This is perfectly normal behavior. You might want to add a sort transformation right before the destination. But still, there are no guarantees that the data will be stored "in order." Tag: MIgrating Existing WorkFlow Data using SSIS
  - 11
    - SQL Server install It could be you are running the wrong Vista because some Vista comes with limited IIS7 so the link below will show you the check list. What I mean is Ultimate is the only home Vista edition that you can use for Reporting services, so if you have the correct Vista edition then go to the second link and enable all the Asp.net components you need. Hope this helps. http://www.iis.net/articles/view.aspx/IIS7/Deploy-an-IIS7-Server/Installing-IIS7/IIS7-Features-and-Windows-Vista-Editions http://blogs.msdn.com/bwelcker/archive/2007/03/19/candy-apple-grey-installing-ssrs-and-windows-vista.aspx Tag: MIgrating Existing WorkFlow Data using SSIS
  - 12
    - stored procedure parsing comments incorrectly If you can reproduce the issue then I suggest you raise a bug on http://connect.microsoft.com/sqlserver Tag: MIgrating Existing WorkFlow Data using SSIS
  - 13
    - Using XML Source in SSIS vs Script Source to parse xml files. I've been using the XML Source to process a large nested XML file. In my case, the contents need to be placed into several tables, so it's a little different from your situation. On the other hand, my input XML is actually much more complex than it really needs to be. It's organized for ease of creation, not ease of consumption. If I had used that external-facing schema directly, the XML Source would have produced 149 outputs and 149 error outputs (yes, one hundred fourty-nine). My solution was to run the XML through a transform to flatten it. This left me with only (!) 38 outputs and 38 error outputs. Perhaps you can flatten your XML with an XSL transform before your XML source consumes it. You could use an XML Task to do this. Just have the task run before your data flow. Also, be aware that there are several issues with the XML Source. Most of these appear to be proportional to the number of outputs, so you'll do well to limit the number of outputs. Also, note that the XML transform completely invalidates its external metadata whenever it notices that the schema has changed. Even a trivial change will cause it to invalidate everything, requiring you to fix the metadata for all subsequent components. This usually just takes time and care, but once it forgot the names of the columns, which cost a day to fix. Good luck. There don't appear to be many people using the XML Source. Tag: MIgrating Existing WorkFlow Data using SSIS
  - 14
    - Select Time, WHERE @filename BETWEEN @theEndTime AND @theCurTime But I want to have the substrings from FILENAME into the variable @temp11filename. I want to mask out 2007-05-06 18:18:00 from filename_wast_erth1_20070506_1818_all.txt. 2007-05-06 18:18:00 is the date I want to use as argument when getting the rows. @temp11filename = SUBSTRING ( FILENAME , 21 , 4 )+ '-' + SUBSTRING ( FILENAME , 25 , 2 )+ '-' + SUBSTRING ( FILENAME , 27 , 2 )+ ' ' + SUBSTRING ( FILENAME , 30 , 2 )+ ':' + SUBSTRING ( FILENAME , 32 , 2 )+ ':00' , Here @temp11filename is 2007-05-06 18:18:00 I want to use @temp11filename to find out and then get all rows between @ theEndTime AND @theCurTime Am I thinking wrong Tag: MIgrating Existing WorkFlow Data using SSIS
  - 15
    - Radio button http://www.devx.com/dotnet/Article/30424/0 Tag: MIgrating Existing WorkFlow Data using SSIS
  - 16
    - Transfer object task error. Hi, i am trying to transfer objects from SQL Server 2000 DB to SQL 2005 DB. i have copy schema to true and i am only copying tables. when i have tried first time it worked fine but in next time it start to give error. here is the error description. [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}". Thanks, Haroon Tag: MIgrating Existing WorkFlow Data using SSIS
- Next
  - 1
    - OLAP Error - Excel Pivot Hiya, We're having exactly the same problem here. Also, with SP3 recently installed. It was fine before. So far, I haven't found any other leads as to what's happened. Tag: MIgrating Existing WorkFlow Data using SSIS
  - 2
    - Cannot connect to SQL Express from WEB Application on internet See this http://msdn2.microsoft.com/en-us/library/ms175483.aspx to enable so. Tag: MIgrating Existing WorkFlow Data using SSIS
  - 3
    - plain text mails One option is to run Profiler as you are trying to send an email from the GUI. That way, you can find out exactly what is being sent to the database. That may help. Tim Tag: MIgrating Existing WorkFlow Data using SSIS
  - 4
    - The Device is not ready error when Executing package on the server No problem... moving to SSIS forum. Tag: MIgrating Existing WorkFlow Data using SSIS
  - 5
    - Unable to install SQL Server 2008 on Windows Vista Hi, I have successfully installed the SQL Server 2008 June CTP side by side an SQL Server 2005 SP 2 installation on Windows Server 2008 Beta 3. I know that SQL2000 installation does not let the SQL2008 installation package to start installing but SQL 2005 does not effect the database engine of SQL 2008 to install on the same server. But the client tools does not install on the same computer where SQL 2005 client tools reside. So uninstalling the client components of SQL2005 may solve the problem before installing the SQL 2008 client tools. Tag: MIgrating Existing WorkFlow Data using SSIS
  - 6
    - Query Plan in SQL Server 2005 SP2 Unfortunately, we do not do a good job of optimizing queries that contain large number of value in the IN list. Part of the problem is the high compilation costs as the number of values increases. This affects plan choices also. If you provide index hint then lot of the logic is short circuited. In this case, it just so happens that using the index results in a good plan. It is hard to say if that will be case for all possible IN list values. Next, I am not sure how you are sending the query to SQL Server. It is very inefficient to send queries like this. Is this being generated from an application How is the user able to select this many values There are also multiple problems apart from the performance issue. For each such unique query, there will be a unique plan because of the difference in the IN list values. This affects your plan cache size too. And it looks like the size of your SQL statement can be very large so it affects performance and also inhibits different connections from sharing the same plan. You should consider the following options: 1. Create a temporary table and optionally index the value column 2. Use BULK INSERT or BCP or BulkCopy API to dump the IN list values into temporary table 3. Write the query to use the temporary table. The query plan can now be shared across connections and independent of the values in the temporary table You can also create a SP that takes the IN list values as a blob (string of bytes) and parse it using SUBSTRING/numbers table. The link below describes lot of these techniques. http://www.sommarskog.se/arrays-in-sql.html So can you describe your query generation process more Tag: MIgrating Existing WorkFlow Data using SSIS
  - 7
    - How to Locate the SSIS Installation? That means that the full SSIS client hasn't been installed. Just the Visual Studio tools. Tag: MIgrating Existing WorkFlow Data using SSIS
  - 8
    - Un-Pivot transform crashes BIDS (Serious Issue) You mean it works fine after you removed and added back the component please provide the details on how you fixed and marked the thread as answered. That would help other people having similar issues Tag: MIgrating Existing WorkFlow Data using SSIS
  - 9
    - Transform collate fields Hi, if you want to sync them to the database default, use the following command: ALTER TABLE SomeTable ALTER COLUMN Test CHAR ( 10 ) COLLATE DATABASE_DEFAULT HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: MIgrating Existing WorkFlow Data using SSIS
  - 10
    - Msg 137, Level 15, State 2, Line 8 / Must declare the scalar variable "@Interest". I got a bit confused to be honnest. I should have used a join. Anyway, I have sorted the problem, Iam only using 1 table since there aren't that many fields. Thanks a lot for your help. Jean-Philippe Tag: MIgrating Existing WorkFlow Data using SSIS
  - 11
    - logistic regression model formual Hi Bogdan, Thanks for the very useful information. Could you also provide examples of how to compute the InputNormalizedValue (i.e. z-score) for Discrete attributes (NODE_DISTRIBUTION.VALUETYPE = 4) In this case, it would seem that the NODE_DISTRIBUTION.PROBABILITY represents the MEAN, but NODE_DISTRIBUTION.VARIANCE is always set to 0. I tried computing the STDEV based on a Bernoulli distribution with the specified probabilities, but the resulting z-scores didn't seem to jive with a MS SQL example I saw online ( http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/1509.aspx ). Also, just to verify, for Continuous attributes (NODE_DISTRIBUTION.VALUETYPE = 3), the z-score would equal (Input Value - NODE_DISTRIBUTION.ATTRIBUTE_VALUE) / SQRT(NODE_DISTRIBUTION.VARIANCE), correct Thanks, Doug Tag: MIgrating Existing WorkFlow Data using SSIS
  - 12
    - How to figure out if the dataset returned any data or not while rendering the report through the SSRS Web Service In one of my projects, i have been using the SSRS web service to render a report as pdf and then manually emailing it out. I need to know whether the data set for the report returned any data or not (so that i can avoid emailing the report with a blank report body). Ofcource this can be done by executing the same query (same as the query for the report) from C# code and checking the count of the resultset, before calling the SSRS Render method. But it might not be an efficient method. Was wondering the the SSRS Web Service provides an property or method that can let me figure out whether the resultset was empty or not (after the report execution). Thanks. Tag: MIgrating Existing WorkFlow Data using SSIS
  - 13
    - How to format cell / data apprearecnce under a table Hello All, I uploaded custtable under the database, the data looks fine except that the name that apprears has a lot of distance e.g it should be : firstname lastname however the format appears very strange: firstname lastname firstname lastname fistname lastname Same is the case with the address, I need to adjust or format the apperance that appears on the cell. Is there a way/ sql statement to format the data under the table so that the apprearence looks okay. I will really appreciate any sort of help on this one. Thanks, Rashi Tag: MIgrating Existing WorkFlow Data using SSIS
  - 14
    - SSIS Script Task Here's another example I posted a while back, maybe it will help. http://agilebi.com/cs/blogs/jwelch/archive/2007/03/21/using-for-each-to-iterate-a-resultset.aspx The variable should be typed as an object. Did you try the suggestion from the other thread to use a script task to see if the variable was set properly Tag: MIgrating Existing WorkFlow Data using SSIS
  - 15
    - Data Conversion Question I am using the instructions at the following link to create an update/insert load: http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx My input data has values that are 8 bit signed integers DT_I8. My output table uses BIGINT for the same fields. Now I know that the conversion in SSIS is BIGINT = DT_STR. The question I have is this. On the INSERT side of the OLE DB Command I did not have to convert the DT_I8 values to write to the table. HOWEVER on the UPDATE side, the update errored out UNTIL I did a data conversion to DT_STR of the same fields. Why is it different between the UPDATE side and the INSERT side Tag: MIgrating Existing WorkFlow Data using SSIS
  - 16
    - How to flush data stored in SSIS buffer Real-time is a difficult term to define. I think SSIS can push data to a destination fast enough to qualify as real-time for most applications. I think what really determines the appropriateness of SSIS for a real-time application is what your source data is. Scenarios that I've been involved with have had message-based sources, and in those cases I've skipped SSIS and consumed the source data with Service Broker. Tag: MIgrating Existing WorkFlow Data using SSIS

hangar18

Hi,

I have posted the same query in the WF group too. Thought I'll post the same here.

We have an existing application which has some WorkFlow Data.

We need to migrate this data using SSIS.

Now the problem here is that we have our Workflow facade class which inturn calls the WorkFlow Runtime.

We have created the methods which will create the new WorkFlows.

TO add this DLL in our SCript Component Reference, we added a strong name to my Facade.dll and deployed it to GAC. The system.WorkFlow DLL's are also present there.

Everytime I run this Package, I get the following error "System.IO.FileNotFoundException: Could not load assembly...".

What am I missing

Thanks

Soni

Top