Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gk53
  • Order by date
  1. gk53

    New line after every 5 words

    I'm not sure it will looks good, but back to original question you can split your text by " " (space) and when reassemble line back insert new line after every 5 array alements
  2. gk53

    SSIS Pckg FTP Task FTP Connection Manager will not store or save password

    Put password in variable and use expressions to configure connection with password from variable
  3. gk53

    SSIS Package stopped in between and throwing below exception

    Add logging to text file to your SSIS it will give you more details on error...
  4. gk53

    SSIS - Extract a Dynamicaly Created Zip File

    Just add script task and in VB or C# if your file YourFileName.csv_2015-12-09_21-17-47.zip In VB it would be Dim fileFolder As String Dim dirDest As DirectoryInfo = New DirectoryInfo(fileFolder) For Each f In GetFiles("YourFileName.csv*.zip") ' unzip your file there Next
  5. gk53

    Session Variables Being Lost

    ...Data Source=" &_ Server.MapPath("x\db.mdb") & ";" myconn.open (connection) set rs = Server.CreateObject("ADODB.recordset") sql = "select * from PaxName where PaxName = ''" rs.open sql, cn, 1, 3 '1 - adOpenKeyset , 3 - adLockOptimistic rs.addNew rs("PaxName") = PaxName rs.Update rs.close...
  6. gk53

    Session Variables Being Lost

    I hope you understand risk of SQL injection when using inline insert statement what if PaxName = "antony; delete from PaxName;" sql = "INSERT INTO table (PaxName) VALUES ('" & PaxName & "')" In your case it will give you sql error, but code executes on database side, so it will delete all...
  7. gk53

    Incremental Load

    The simple way is something like that in Data flow source you running SQL somthing like select field1, field2, field3, field4, field5, field6, field7, ........... fieldN from sourceTabel You need to change to Declare @LastImportDate date select @LastImportDate = value from ParamSettings where...
  8. gk53

    Export data from multiple views to multiple CSV files

    ...and refill with status 'P'. After that "select top 1 @vieName = vieName from myViews where status_cd = 'P'" and "select @isLast = case when count(*) = 1 then 'Y' else 'N' end from myViews where status_cd = 'P'" and last one "select isLast = @isLast , vieName = @vieName" 4. set property on...
  9. gk53

    Getting Value from Last Record in DB

    try something like that If ds.Tables,Count > 0 Then if ds.Tables(0).Rows.Count > 0 then Dim dr As DataRow = ds.Tables(0).Rows(ds.Tables(0).Rows.Count - 1)) t1.Text = dr.Item(0).ToString end if End If or preferable change your query to "select top 1 field from table order by field...
  10. gk53

    Transaction (Process ID 67) was deadlocked on lock

    IS step which giving error update records? If not make sure you use (nolock) attribute when query tables. Search on server log what else running on server at the same time may be problem not in your ssis, but on another process.
  11. gk53

    Need Help Merging Two Queries into One

    it looks like to stand alone queries so first one should be something like ; with e as ( select MIN_anty_pymt_dt = min(anty_pymt_dt), recip_ssn_nbr from dsnp.pr01_t_anty_pymt GROUP BY recip_ssn_nbr ) SELECT a.RECIP_SSN_NBR, CASE when a.RECIP_TYPE_CD = '10'...
  12. gk53

    Is replication transparent?

    It is number of ways to handle identity columns in replication (if you use identity columns). Even if you not doing anything when you set up replication system will create additional columns with and system tables which will track and handle all conflicts It is works pretty well.
  13. gk53

    Is replication transparent?

    It is transparent. I used that architecture. One server in central office and servers in different locations witch connected to internet and running VPN into central office network.
  14. gk53

    Multiple Rows, split order when items total 720g

    make right order on SQL side and after that just send result for file in SSIS
  15. gk53

    CROSS APPLY

    cross apply is analog to inner join, it works created to work with table valued functions if query select F.* from sys.objects O inner join dbo.myTableFun(O.name) F on F.schema_id= O.schema_id giving syntactic error query select F.* from sys.objects O cross apply dbo.myTableFun(O.name) F...
  16. gk53

    Is There a Way to Treat Null Values to be Equal in a WHERE Clause?

    why no simple where ISNULL(@ParameterValue, '') = ISNULL(ColumnValue, '')
  17. gk53

    SSIS -- ETL, then move Excel file

    Is that one file with multiple tabs or multiple excel files? if it is one file, file will be on lock until all data flow tasks completed. you should put all your data flow tasks in one Sequence Container and File System Task after Sequence Container
  18. gk53

    Latest Records with associated Data - Query not working

    ...'Pended' union select 104, 5551111,'CS', 'Closed' union select 105, 5551111,'Support', 'Open' union select 106, 5553333,'CS', 'Open' select t.* from @Table t join ( select phone, recid = MAX(UniqueRecord) from @Table group by phone ) u on u.recid = t.UniqueRecord order by...
  19. gk53

    Have I got too many if's

    it looks like your problem outside of your published code... look on commented html...
  20. gk53

    Checking input date agains a file of holidays

    Yes Chris absolutely right... you can stick somewhere in javascript array of holidays and check against that array or use ajax call from javascript to server with selected value and get from another asp page on server result

Part and Inventory Search

Back
Top